APPS.PO_POXRVXRV_XMLP_PKG SQL Statements

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

Line: 14

		select organization_name
		into l_org_displayed
		from org_organization_definitions
		where organization_id = P_org_id ;

Line: 123

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;

Line: 150

	SELECT 	manual_po_num_type
	, 	manual_req_num_type
 	INTO	po_numbering_type
	,	req_numbering_type
 	FROM 	po_system_parameters;

Line: 348

     select hrtl.location_code
     into  x_location_code
     from  hr_locations_all hrl,
           hr_locations_all_tl hrtl
     where hrl.location_id = location_id1
     and   hrl.location_id = hrtl.location_id
     and   hrtl.language   = userenv('LANG');

Line: 359

          select substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,20) location_code
          into x_location_code
          from  hz_locations hz
          where hz.location_id = location_id1;

Line: 376

      select location_id
      into p_location_id
      from hr_locations_all
      where location_code = P_location;