APPS.PO_POXVDRVL_XMLP_PKG SQL Statements

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

Line: 33

    select displayed_field
    into l_active_inactive
    from po_lookup_codes
    where lookup_code = P_active_inactive
    and lookup_type = 'ACTIVE_INACTIVE';

Line: 49

    select displayed_field
    into l_vendor_type
    from po_lookup_codes
    where lookup_code = P_vendor_type
    and lookup_type = 'VENDOR TYPE';

Line: 66

    select displayed_field
    into l_sort
    from po_lookup_codes
    where lookup_code = P_orderby
    and lookup_type = 'SRS ORDER BY';