APPS.PO_CHVPRSCH_XMLP_PKG SQL Statements

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

Line: 47

     UPDATE chv_schedule_headers
       SET  last_print_date        = sysdate
       ,    print_count            = decode(print_count,
                                            NULL, 1,
                                            print_count + 1)
       WHERE  schedule_id = csh_schedule_id;

Line: 68

  SELECT LOC.ADDRESS_LINE_1||decode(LOC.ADDRESS_LINE_1, null, null,', ')||
         LOC.ADDRESS_LINE_2||decode(LOC.ADDRESS_LINE_2, null, null,', ')||
         LOC.ADDRESS_LINE_3||decode(LOC.ADDRESS_LINE_3, null, null,', ')||
         LOC.TOWN_OR_CITY||decode(LOC.TOWN_OR_CITY, null, null,', ')||
         LOC.REGION_2||decode(LOC.REGION_2, null, null,', ')||
         LOC.COUNTRY||decode(LOC.COUNTRY, null, null,',  ')||
         LOC.POSTAL_CODE
  INTO   x_address
  FROM   hr_locations_all LOC,
         hr_organization_units UNITS
  WHERE
  	 UNITS.LOCATION_ID = LOC.LOCATION_ID AND
	 organization_id = UNITS.ORGANIZATION_ID;