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 349: pay_patch_status pps

345: substr(pgu.description,1,65)
346: from per_people_f ppf,
347: per_assignments_f pef,
348: pay_us_geo_update pgu,
349: pay_patch_status pps
350: where pef.assignment_id = pgu.assignment_id
351: and ppf.person_id = pef.person_id
352: and pgu.id = pps.id
353: and pps.patch_name = p_geocode_patch_name

Line 548: pay_patch_status pps

544: substr(pef.assignment_number,1,17)
545: from per_people_f ppf,
546: per_assignments_f pef,
547: pay_us_geo_update pgu,
548: pay_patch_status pps
549: where pgu.process_type = 'PERCENTAGE_OVER_100'
550: and pef.assignment_id = pgu.assignment_id
551: and ppf.person_id = pef.person_id
552: and pgu.process_mode = p_process_mode

Line 733: pay_patch_status pps

729: substr(pef.assignment_number,1,17)
730: from per_people_f ppf,
731: per_assignments_f pef,
732: pay_us_geo_update pgu,
733: pay_patch_status pps
734: where pgu.process_type = 'MISSING_COUNTY_RECORDS'
735: and pef.assignment_id = pgu.assignment_id
736: and ppf.person_id = pef.person_id
737: and pgu.process_mode = cp_process_mode

Line 916: pay_patch_status pps,

912: substr(pmod.city_name,1,20),
913: substr(pgu.table_name ,1,20)
914: from pay_us_modified_geocodes pmod,
915: pay_us_city_names pusc ,
916: pay_patch_status pps,
917: per_people_f ppf,
918: per_assignments_f pef,
919: pay_us_geo_update pgu
920: where pgu.process_type = 'PU'

Line 1155: pay_patch_status pps

1151: from per_people_f ppf,
1152: per_assignments_f pef,
1153: pay_us_geo_update pgu,
1154: pay_us_city_names pusc,
1155: pay_patch_status pps
1156: where pgu.process_type = 'UP'
1157: and pgu.table_name is not null
1158: and pef.assignment_id = pgu.assignment_id
1159: and ppf.person_id = pef.person_id

Line 1372: pay_patch_status pps ,

1368: from per_people_f ppf,
1369: per_assignments_f pef,
1370: pay_us_geo_update pgu,
1371: pay_us_city_names pusc,
1372: pay_patch_status pps ,
1373: pay_us_states pust,
1374: pay_us_counties puscn
1375: where pgu.process_type = 'US'
1376: and pgu.status = 'A'

Line 2020: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */

2016: ) is
2017:
2018: select /*+ ORDERED
2019: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2)
2020: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2021: distinct substr(ppf.full_name,1,40) ,
2022: pef.assignment_id ,
2023: substr(pef.assignment_number,1,17),
2024: substr(pusc.city_name,1,20),

Line 2026: from pay_patch_status pps,

2022: pef.assignment_id ,
2023: substr(pef.assignment_number,1,17),
2024: substr(pusc.city_name,1,20),
2025: pgu.new_juri_code
2026: from pay_patch_status pps,
2027: pay_us_geo_update pgu,
2028: pay_us_city_names pusc,
2029: per_assignments_f pef,
2030: per_people_f ppf

Line 2224: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */

2220: ) is
2221:
2222: select /*+ ORDERED
2223: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2 )
2224: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2225: distinct substr(ppf.full_name,1,40) ,
2226: pef.assignment_id ,
2227: substr(pef.assignment_number,1,17),
2228: substr(pusc.city_name,1,20),

Line 2230: from pay_patch_status pps,

2226: pef.assignment_id ,
2227: substr(pef.assignment_number,1,17),
2228: substr(pusc.city_name,1,20),
2229: pgu.new_juri_code
2230: from pay_patch_status pps,
2231: pay_us_geo_update pgu,
2232: pay_us_city_names pusc,
2233: per_assignments_f pef,
2234: per_people_f ppf

Line 2433: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */

2429: ) is
2430:
2431: select /*+ ORDERED
2432: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2 )
2433: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2434: distinct old_juri_code ,
2435: new_juri_code
2436: from pay_patch_status pps,
2437: pay_us_geo_update pgu

Line 2436: from pay_patch_status pps,

2432: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2 )
2433: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2434: distinct old_juri_code ,
2435: new_juri_code
2436: from pay_patch_status pps,
2437: pay_us_geo_update pgu
2438: where pgu.process_type = 'TAX_RULES_CHANGE'
2439: and pgu.process_mode = cp_process_mode
2440: and pgu.id = pps.id