Is this ultra simple stuff or am I missing the banana boat yet again..

why is


PHP Code:

SELECT company
.DESCR
       
company.DESCRSHORT 
  FROM PS_company_TBL COMPANY 
 WHERE 
:company.company 
   
AND company.EFFDT = (SELECT MAX(C2.EFFDT
                          
FROM PS_COMPANY_TBL C2 
                         WHERE 
:C2.COMPANY 
                           
AND C2.EFFDT <= SYSDATE
different than this

PHP Code:


SELECT company
.DESCR
       
company.DESCRSHORT 
  FROM PS_company_TBL COMPANY 
 WHERE company
.company = :
   
AND company.EFFDT = (SELECT MAX(C2.EFFDT
                          
FROM PS_COMPANY_TBL C2 
                         WHERE C2
.COMPANY COMPANY.COMPANY 
                           
AND C2.EFFDT <= SYSDATE
specifically why is the top one cost 2 and the bottom one cost of 12 when essentially all I have done is put the bind variable on the right in the bottom statement