APPS.PAY_US_GEOCODE_ENGINE_PKG SQL Statements

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

Line: 11

        select patch_name,
               Substr( patch_name,
                       greatest(instr(patch_name,'_1'),instr(patch_name,'_2')) + 1, 4)
        from pay_patch_status
        where patch_name like '%GEO%'
          and Substr( patch_name,
                      greatest(instr(patch_name,'_1'),instr(patch_name,'_2')) + 1, 4) >= '2001'
        group by patch_name
        order by patch_name desc;

Line: 23

        select patch_name,
               Substr( patch_name,
                       greatest(instr(patch_name,'_1'),instr(patch_name,'_2')) + 1, 4)
        from pay_us_modified_geocodes
        where patch_name like '%GEO%'
          and Substr( patch_name,
                      greatest(instr(patch_name,'_1'),instr(patch_name,'_2')) + 1, 4) >= '2001'
        group by patch_name
        order by patch_name asc;

Line: 35

        select status
        from pay_patch_status
        where patch_name = p_patch_name
        order by patch_name asc;

Line: 42

      select status
      from pay_patch_status
      where patch_name = p_patch_name;

Line: 48

	select count (tr.assignment_id)
	from pay_us_modified_geocodes mg,
	     pay_us_emp_city_tax_rules_f tr,
             per_all_assignments_f paf,
             pay_us_states pus
	where mg.patch_name = p_patch_name
	  and mg.state_code = pus.state_code
	  and mg.state_code = tr.state_code
	  and mg.county_code = tr.county_code
	  and mg.old_city_code = tr.city_code
	  and tr.assignment_id = paf.assignment_id;

Line: 63

	select count(pac.assignment_id)
	from   per_all_assignments_f paf,
	       pay_action_contexts pac,
               pay_us_modified_geocodes pmod
	where  pmod.state_code = '70'
          and  pmod.county_code = pac.context_value
	  and  pac.context_id  in (select context_id
                               from ff_contexts
                               where context_name = 'jurisdiction_code')
	  and  pmod.patch_name = p_patch_name
	  and  pac.assignment_id = paf.assignment_id;

Line: 190

             select number_of_copies,
                   printer,
                   print_style,
                   save_output_flag
             into  copies_buffer,
                   printer_buffer,
                   style_buffer,
                   save_result
             from  fnd_concurrent_requests
             where request_id = fnd_number.canonical_to_number(req_id);

Line: 235

                               argument2      => 'GEO_UPDATE',
                               argument3      => 'DEFAULT',
                               argument4      => to_date('01/01/'||l_year, 'dd/mm/yyyy'),
                               argument5      => sysdate,
                               argument6      => 'REPORT',
                               argument7      => fnd_profile.value('PER_BUSINESS_GROUP_ID'),
                               argument8      => 'DUMMY',
                               argument9      => p_mode,  -- l_mode
                               argument10     => l_patch_name,  -- patch_name
                               argument11     => 'PATCH_NAME=' || l_patch_name,
                               argument12     => 'MODE=' || p_mode );

Line: 269

	insert into pay_patch_status
                 (ID,
                  PATCH_NUMBER,
                  PATCH_NAME,
                  PHASE,
                  PROCESS_TYPE,
                  APPLIED_DATE,
                  STATUS,
                  DESCRIPTION,
                  UPDATE_DATE,
                  LEGISLATION_CODE,
                  APPLICATION_RELEASE,
                  PREREQ_PATCH_NAME)
                values
                  (PAY_PATCH_STATUS_S.nextval,
                   '1111111',
                   l_patch_name, --p_patch_name,
                   null,
                   null,
                   sysdate,
                   'C',
                   null, -- lv_patch_desc,
                   null,
                   'US',
                   '115',
                   'Q2' );

Line: 319

                    update pay_patch_status
                    set patch_name = 'DEBUG_' || l_patch_name
                    where patch_name = l_patch_name;

Line: 340

        update pay_patch_status
        set patch_name = 'DEBUG_' || l_patch_name
        where patch_name = l_patch_name;