APPS.PO_HXC_INTERFACE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 284

      SELECT 'Y'
      FROM   hxc_Time_Building_Blocks htb,
             hxc_Time_Attributes hta,
             hxc_Time_Attribute_Usages htau
      WHERE  hta.Time_Attribute_Id = htau.Time_Attribute_Id
             AND htau.Time_Building_Block_Id = htb.Time_Building_Block_Id
             AND htau.Time_Building_Block_ovn = htb.Object_Version_Number
             AND htb.Date_To = hr_General.End_Of_Time
             AND htb.Scope = 'DETAIL'
             AND hta.Attribute_Category = 'PURCHASING'
             AND hta.Attribute2 = To_Char(po_line_id)
             AND htb.Resource_Id = p_person_id
             AND ROWNUM = 1;