APPS.PO_POXSURLC_XMLP_PKG SQL Statements

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

Line: 22

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

Line: 32

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

Line: 42

    select displayed_field
    into l_site
    from po_lookup_codes
    where lookup_code = P_site
    and lookup_type = 'SITE_TYPE';