eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on PAY_PATCH_STATUS

Line 700: pay_patch_status pps,

696: substr(pgu.description,1,65)
697: from per_people_f ppf,
698: per_assignments_f pef,
699: pay_us_geo_update pgu,
700: pay_patch_status pps,
701: pay_us_emp_city_tax_rules_f pctrf
702: where pef.assignment_id = pgu.assignment_id
703: and pctrf.assignment_id = pef.assignment_id
704: and pctrf.effective_start_Date <= pef.effective_end_date

Line 912: pay_patch_status pps

908: substr(pef.assignment_number,1,17)
909: from per_people_f ppf,
910: per_assignments_f pef,
911: pay_us_geo_update pgu,
912: pay_patch_status pps
913: where pgu.process_type = 'PERCENTAGE_OVER_100'
914: and pef.assignment_id = pgu.assignment_id
915: and ppf.person_id = pef.person_id
916: and pgu.process_mode = p_process_mode

Line 1097: pay_patch_status pps

1093: substr(pef.assignment_number,1,17)
1094: from per_people_f ppf,
1095: per_assignments_f pef,
1096: pay_us_geo_update pgu,
1097: pay_patch_status pps
1098: where pgu.process_type = 'MISSING_COUNTY_RECORDS'
1099: and pef.assignment_id = pgu.assignment_id
1100: and ppf.person_id = pef.person_id
1101: and pgu.process_mode = cp_process_mode

Line 1280: pay_patch_status pps,

1276: substr(pmod.city_name,1,30),
1277: substr(pgu.table_name ,1,20)
1278: from pay_us_modified_geocodes pmod,
1279: pay_us_city_names pusc ,
1280: pay_patch_status pps,
1281: per_people_f ppf,
1282: per_assignments_f pef,
1283: pay_us_geo_update pgu
1284: where pgu.process_type = 'PU'

Line 1519: pay_patch_status pps

1515: from per_people_f ppf,
1516: per_assignments_f pef,
1517: pay_us_geo_update pgu,
1518: pay_us_city_names pusc,
1519: pay_patch_status pps
1520: where pgu.process_type = 'UP'
1521: and pgu.table_name is not null
1522: and pef.assignment_id = pgu.assignment_id
1523: and ppf.person_id = pef.person_id

Line 1736: pay_patch_status pps ,

1732: from per_people_f ppf,
1733: per_assignments_f pef,
1734: pay_us_geo_update pgu,
1735: pay_us_city_names pusc,
1736: pay_patch_status pps ,
1737: pay_us_states pust,
1738: pay_us_counties puscn
1739: where pgu.process_type = 'US'
1740: and pgu.status = 'A'

Line 2382: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */

2378: ) is
2379:
2380: select /*+ ORDERED
2381: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2)
2382: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2383: distinct substr(ppf.full_name,1,40) ,
2384: pef.assignment_id ,
2385: substr(pef.assignment_number,1,17),
2386: substr(pusc.city_name,1,30),

Line 2388: from pay_patch_status pps,

2384: pef.assignment_id ,
2385: substr(pef.assignment_number,1,17),
2386: substr(pusc.city_name,1,30),
2387: pgu.new_juri_code
2388: from pay_patch_status pps,
2389: pay_us_geo_update pgu,
2390: pay_us_city_names pusc,
2391: per_assignments_f pef,
2392: per_people_f ppf

Line 2586: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */

2582: ) is
2583:
2584: select /*+ ORDERED
2585: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2 )
2586: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2587: distinct substr(ppf.full_name,1,40) ,
2588: pef.assignment_id ,
2589: substr(pef.assignment_number,1,17),
2590: substr(pusc.city_name,1,30),

Line 2592: from pay_patch_status pps,

2588: pef.assignment_id ,
2589: substr(pef.assignment_number,1,17),
2590: substr(pusc.city_name,1,30),
2591: pgu.new_juri_code
2592: from pay_patch_status pps,
2593: pay_us_geo_update pgu,
2594: pay_us_city_names pusc,
2595: per_assignments_f pef,
2596: per_people_f ppf

Line 2795: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */

2791: ) is
2792:
2793: select /*+ ORDERED
2794: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2 )
2795: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2796: distinct old_juri_code ,
2797: new_juri_code
2798: from pay_patch_status pps,
2799: pay_us_geo_update pgu

Line 2798: from pay_patch_status pps,

2794: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2 )
2795: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2796: distinct old_juri_code ,
2797: new_juri_code
2798: from pay_patch_status pps,
2799: pay_us_geo_update pgu
2800: where pgu.process_type = 'TAX_RULES_CHANGE'
2801: and pgu.process_mode = cp_process_mode
2802: and pgu.id = pps.id

Line 2991: pay_patch_status pps

2987: cursor c_county_name_change (cp_geocode_patch_name in varchar) is
2988:
2989: SELECT pugp.new_juri_code,pugp.description
2990: FROM pay_us_geo_update pugp,
2991: pay_patch_status pps
2992: WHERE pugp.table_name in ('PER_ADDRESSES','HR_LOCATIONS_ALL')
2993: AND pugp.process_type = 'CN'
2994: AND pugp.id = pps.id
2995: AND pps.patch_name = cp_geocode_patch_name

Line 4100: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */

4096: ) is
4097:
4098: select /*+ ORDERED
4099: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2)
4100: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
4101: distinct substr(ppf.full_name,1,40) ,
4102: ppf.person_id ,
4103: ppf.employee_number,
4104: pgu.new_juri_code,

Line 4108: from pay_patch_status pps,

4104: pgu.new_juri_code,
4105: pumg1.city_name old_city_name,
4106: pumg2.city_name new_city_name,
4107: substr(pgu.description,1,instr(pgu.description,':')-1)
4108: from pay_patch_status pps,
4109: pay_us_geo_update pgu,
4110: per_people_f ppf,
4111: per_addresses pa,
4112: pay_us_modified_geocodes pumg1,

Line 4147: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */

4143: ) is
4144:
4145: select /*+ ORDERED
4146: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2)
4147: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
4148: distinct substr(hl.location_code,1,40) ,
4149: hl.location_id ,
4150: pgu.new_juri_code,
4151: pumg1.city_name old_city_name,

Line 4154: from pay_patch_status pps,

4150: pgu.new_juri_code,
4151: pumg1.city_name old_city_name,
4152: pumg2.city_name new_city_name,
4153: substr(pgu.description,1,instr(pgu.description,':')-1)
4154: from pay_patch_status pps,
4155: pay_us_geo_update pgu,
4156: hr_locations_all hl,
4157: pay_us_modified_geocodes pumg1,
4158: pay_us_modified_geocodes pumg2

Line 4190: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */

4186: ,cp_geocode_patch_name in varchar
4187: ) is
4188: select /*+ ORDERED
4189: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2)
4190: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
4191: distinct substr(hou.name,1,40) ,
4192: hoi.organization_id ,
4193: pgu.new_juri_code,
4194: pumg1.city_name old_city_name,

Line 4198: from pay_patch_status pps,

4194: pumg1.city_name old_city_name,
4195: pumg2.city_name new_city_name,
4196: NVL(hoit.displayed_org_information_type,fdfv.descriptive_flex_context_name)||
4197: ', '||fdfc.form_left_prompt
4198: from pay_patch_status pps,
4199: pay_us_geo_update pgu,
4200: hr_organization_information hoi,
4201: hr_organization_units hou,
4202: fnd_descr_flex_contexts_vl fdfv,

Line 4825: lv_patch_name pay_patch_status.patch_name%TYPE;

4821:
4822: IS
4823:
4824: lv_output_file_type varchar2(4);
4825: lv_patch_name pay_patch_status.patch_name%TYPE;
4826:
4827: BEGIN
4828:
4829: lv_output_file_type := 'HTML';

Line 4833: FROM pay_patch_status

4829: lv_output_file_type := 'HTML';
4830:
4831: SELECT patch_name
4832: INTO lv_patch_name
4833: FROM pay_patch_status
4834: WHERE id = p_geo_phase_id;
4835:
4836: fnd_file.put_line(fnd_file.output, formated_header_string(
4837: 'Patch Name : '||lv_patch_name