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 PER_PEOPLE_F

Line 697: from per_people_f ppf,

693: select distinct substr(ppf.full_name,1,40) ,
694: pef.assignment_id ,
695: substr(pef.assignment_number,1,17) ,
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

Line 909: from per_people_f ppf,

905:
906: select distinct substr(ppf.full_name,1,40) ,
907: pef.assignment_id ,
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'

Line 1094: from per_people_f ppf,

1090:
1091: select distinct substr(ppf.full_name,1,40) ,
1092: pef.assignment_id ,
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'

Line 1281: per_people_f ppf,

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'
1285: and pef.assignment_id = pgu.assignment_id

Line 1515: from per_people_f ppf,

1511: substr(pusc.city_name,1,30),
1512: old_juri_code "Old JD",
1513: new_juri_code "New JD",
1514: substr(table_name,1,20)
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

Line 1732: from per_people_f ppf,

1728: substr(puscn.county_name,1,20),
1729: substr(pust.state_abbrev,1,2),
1730: old_juri_code ,
1731: new_juri_code
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 ,

Line 2007: per_people_f ppf

2003: FROM pay_us_modified_geocodes pmod,
2004: pay_us_city_names pucn,
2005: pay_us_emp_city_tax_rules_f ectr,
2006: per_assignments_f paf,
2007: per_people_f ppf
2008: WHERE pmod.process_type = 'P'
2009: AND pmod.state_code = pucn.state_code
2010: AND pmod.county_code = pucn.county_code
2011: AND pmod.new_city_code = pucn.city_code

Line 2031: per_people_f ppf,

2027: SUBSTR(pmod.city_name,1,30)
2028: FROM pay_us_modified_geocodes pmod,
2029: pay_us_emp_city_tax_rules_f ectr,
2030: per_assignments_f paf,
2031: per_people_f ppf,
2032: pay_us_modified_geocodes pmod2
2033: WHERE pmod.process_type = 'S'
2034: and pmod2.process_type in ('UP','PU','P')
2035: and pmod2.state_code = ectr.state_code

Line 2392: per_people_f ppf

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
2393: where pgu.process_type = 'NEW_CITY_RECORDS'
2394: and pef.assignment_id = pgu.assignment_id
2395: and ppf.person_id = pef.person_id
2396: and pusc.city_code = substr(new_juri_code,8,4)

Line 2596: per_people_f ppf

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
2597: where pgu.process_type = 'NEW_VERTEX_RECORDS'
2598: and pef.assignment_id = pgu.assignment_id
2599: and ppf.person_id = pef.person_id
2600: and pusc.city_code = substr(new_juri_code,8,4)

Line 2967: per_people_f ppf,

2963: substr(puc2.county_name,1,20)
2964: FROM pay_us_modified_geocodes pmod,
2965: pay_us_emp_city_tax_rules_f ectr,
2966: per_assignments_f paf,
2967: per_people_f ppf,
2968: pay_us_counties puc1,
2969: pay_us_counties puc2
2970: WHERE ppf.person_id = paf.person_id
2971: AND pmod.state_code = ectr.state_code

Line 4110: per_people_f ppf,

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,
4113: pay_us_modified_geocodes pumg2
4114: where pgu.process_type = 'CY'

Line 4237: ln_full_name per_people_f.full_name%TYPE;

4233: order by hoi.organization_id;
4234:
4235: ln_city_name_change c_city_name_change%ROWTYPE;
4236:
4237: ln_full_name per_people_f.full_name%TYPE;
4238: ln_person_id per_people_f.person_id%TYPE;
4239: ln_employee_number per_people_f.employee_number%TYPE;
4240: ln_jurisdiction_code pay_us_geo_update.new_juri_code%TYPE;
4241: ln_old_city_name pay_us_modified_geocodes.city_name%TYPE;

Line 4238: ln_person_id per_people_f.person_id%TYPE;

4234:
4235: ln_city_name_change c_city_name_change%ROWTYPE;
4236:
4237: ln_full_name per_people_f.full_name%TYPE;
4238: ln_person_id per_people_f.person_id%TYPE;
4239: ln_employee_number per_people_f.employee_number%TYPE;
4240: ln_jurisdiction_code pay_us_geo_update.new_juri_code%TYPE;
4241: ln_old_city_name pay_us_modified_geocodes.city_name%TYPE;
4242: ln_new_city_name pay_us_modified_geocodes.city_name%TYPE;

Line 4239: ln_employee_number per_people_f.employee_number%TYPE;

4235: ln_city_name_change c_city_name_change%ROWTYPE;
4236:
4237: ln_full_name per_people_f.full_name%TYPE;
4238: ln_person_id per_people_f.person_id%TYPE;
4239: ln_employee_number per_people_f.employee_number%TYPE;
4240: ln_jurisdiction_code pay_us_geo_update.new_juri_code%TYPE;
4241: ln_old_city_name pay_us_modified_geocodes.city_name%TYPE;
4242: ln_new_city_name pay_us_modified_geocodes.city_name%TYPE;
4243: ln_update_description pay_us_geo_update.description%TYPE;