APPS.PO_POXPOCOM_XMLP_PKG SQL Statements

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

Line: 20

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

Line: 29

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

Line: 42

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

Line: 52

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

Line: 111

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;

Line: 130

     select distinct gps.period_num, gps.period_year
     into l_period_num, l_period_year
     from gl_period_statuses		gps,
	  financials_system_parameters fsp
     where gps.period_name = P_PERIOD
     and gps.set_of_books_id = fsp.set_of_books_id ;

Line: 160

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

Line: 167

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

Line: 174

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