APPS.PO_HXC_INTERFACE_PVT SQL Statements

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

Line: 76

    SELECT
      sign(count(*))
    INTO
      l_exists_flag
    FROM
      PO_LINES_ALL LINE
    WHERE
        LINE.PO_HEADER_ID = p_field_value
    AND LINE.ORDER_TYPE_LOOKUP_CODE = c_RATE;

Line: 87

    SELECT
      sign(count(*))
    INTO
      l_exists_flag
    FROM
      PO_LINES_ALL LINE
    WHERE
        LINE.PO_LINE_ID = p_field_value
    AND LINE.order_type_lookup_code = c_RATE;

Line: 450

      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;