APPS.PO_POXRQUNI_XMLP_PKG SQL Statements

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

Line: 26

     SELECT meaning
     INTO l_yes_no
     FROM FND_LOOKUPS
     WHERE lookup_type = 'YES_NO'
     AND lookup_code = P_PRINT_PRICE_HISTORY_1;

Line: 87

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;

Line: 107

     select hlt.location_id
     into p_location_id
     from hr_locations_all_tl hlt
     where hlt.location_code = p_location
           and hlt.language=userenv('LANG');

Line: 134

     select hlt.location_code
     into x_location_code
     from hr_locations_all_tl hlt
     where hlt.location_id=p_location_id
           and hlt.language=userenv('LANG');

Line: 142

     select (substr(hzl.address1,1,50) || '-' || hzl.city )
     into x_location_code
     from hz_locations hzl
     where hzl.location_id = location_id;