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_US_MODIFIED_GEOCODES

Line 1269: select /+ index(pmod PAY_US_MODIFIED_GEOCODES_PK)/ -- Bug 3350007

1265: cursor c_cursor ( cp_process_mode in varchar
1266: ,cp_geocode_patch_name in varchar
1267: ) is
1268:
1269: select /*+ index(pmod PAY_US_MODIFIED_GEOCODES_PK)*/ -- Bug 3350007
1270: distinct substr(ppf.full_name,1,40) ,
1271: pef.assignment_id ,
1272: substr(pef.assignment_number,1,17),
1273: pgu.new_juri_code ,

Line 1278: from pay_us_modified_geocodes pmod,

1274: substr(pusc.city_name,1,30),
1275: pgu.old_juri_code,
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,

Line 1997: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1)

1993: ,cp_geocode_patch_name in varchar
1994: ) is
1995:
1996: SELECT /*+ ORDERED
1997: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1)
1998: INDEX (PAY_US_CITY_NAMES PAY_US_CITY_NAMES_FK1)
1999: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */
2000: SUBSTR(ppf.full_name,1,40),
2001: SUBSTR(pmod.city_name,1,30),

Line 2003: FROM pay_us_modified_geocodes pmod,

1999: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */
2000: SUBSTR(ppf.full_name,1,40),
2001: SUBSTR(pmod.city_name,1,30),
2002: SUBSTR(pucn.city_name,1,30)
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

Line 2023: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1)

2019: AND pay_us_geo_upd_pkg.get_city(paf.person_id, paf.location_id, ectr.state_code,
2020: ectr.county_code,ectr.city_code,pmod.city_name,pmod.patch_name,pmod.process_type) = pmod.city_name
2021: UNION
2022: SELECT /*+ ORDERED
2023: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1)
2024: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */
2025: SUBSTR(ppf.full_name,1,40),
2026: SUBSTR(pmod2.city_name,1,30),
2027: SUBSTR(pmod.city_name,1,30)

Line 2028: FROM pay_us_modified_geocodes pmod,

2024: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */
2025: SUBSTR(ppf.full_name,1,40),
2026: SUBSTR(pmod2.city_name,1,30),
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

Line 2032: pay_us_modified_geocodes pmod2

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
2036: and pmod2.county_code = ectr.county_code

Line 2216: from pay_us_modified_geocodes

2212:
2213: select distinct state_code||'-'||county_code||'-'||old_city_code ,
2214: state_code||'-'||county_code||'-'||new_city_code ,
2215: substr(city_name,1,30)
2216: from pay_us_modified_geocodes
2217: where old_city_code like 'U%';
2218:
2219:
2220: ln_old_juri_code varchar2(11);

Line 2954: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1) */

2950: ,cp_geocode_patch_name in varchar
2951: ) is
2952:
2953: SELECT /*+ ORDERED
2954: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1) */
2955: distinct
2956: substr(ppf.full_name,1,40),
2957: paf.assignment_id ,
2958: substr(paf.assignment_number,1,17),

Line 2964: FROM pay_us_modified_geocodes pmod,

2960: ectr.jurisdiction_code,
2961: substr(puc1.county_name,1,20),
2962: pmod.state_code||'-'||pmod.new_county_code||'-'||pmod.new_city_code "New JD",
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,

Line 3452: -- count for pay_us_modified_geocodes --

3448: lv_data_row := '' || lv_data_row || '' ;
3449:
3450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3451:
3452: -- count for pay_us_modified_geocodes --
3453:
3454: ln_row_count := 0;
3455:
3456: select count(*)

Line 3458: from pay_us_modified_geocodes;

3454: ln_row_count := 0;
3455:
3456: select count(*)
3457: into ln_row_count
3458: from pay_us_modified_geocodes;
3459:
3460: formated_static_data( 'PAY_US_MODIFIED_GEOCODES'
3461: ,ln_row_count
3462: ,null

Line 3460: formated_static_data( 'PAY_US_MODIFIED_GEOCODES'

3456: select count(*)
3457: into ln_row_count
3458: from pay_us_modified_geocodes;
3459:
3460: formated_static_data( 'PAY_US_MODIFIED_GEOCODES'
3461: ,ln_row_count
3462: ,null
3463: ,null
3464: ,null

Line 4068: FROM pay_us_modified_geocodes pumg1,

4064: puc.county_code,
4065: pumg1.old_city_code,
4066: pumg1.city_name old_city_name,
4067: pumg2.city_name new_city_name
4068: FROM pay_us_modified_geocodes pumg1,
4069: pay_us_modified_geocodes pumg2,
4070: pay_us_states pus,
4071: pay_us_counties puc
4072: WHERE pus.state_code = puc.state_code

Line 4069: pay_us_modified_geocodes pumg2,

4065: pumg1.old_city_code,
4066: pumg1.city_name old_city_name,
4067: pumg2.city_name new_city_name
4068: FROM pay_us_modified_geocodes pumg1,
4069: pay_us_modified_geocodes pumg2,
4070: pay_us_states pus,
4071: pay_us_counties puc
4072: WHERE pus.state_code = puc.state_code
4073: AND pus.state_code = pumg1.state_code

Line 4112: pay_us_modified_geocodes pumg1,

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'
4115: and pgu.table_name = 'PER_ADDRESSES'
4116: and ppf.person_id = pgu.person_id

Line 4113: pay_us_modified_geocodes pumg2

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'
4115: and pgu.table_name = 'PER_ADDRESSES'
4116: and ppf.person_id = pgu.person_id
4117: and pa.person_id = ppf.person_id

Line 4157: pay_us_modified_geocodes pumg1,

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
4159: where pgu.process_type = 'CY'
4160: and pgu.table_name = 'HR_LOCATIONS_ALL'
4161: and hl.location_id = pgu.table_value_id

Line 4158: pay_us_modified_geocodes pumg2

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
4159: where pgu.process_type = 'CY'
4160: and pgu.table_name = 'HR_LOCATIONS_ALL'
4161: and hl.location_id = pgu.table_value_id
4162: and pgu.process_mode = cp_process_mode

Line 4205: pay_us_modified_geocodes pumg1,

4201: hr_organization_units hou,
4202: fnd_descr_flex_contexts_vl fdfv,
4203: fnd_descr_flex_col_usage_vl fdfc,
4204: hr_org_information_types hoit,
4205: pay_us_modified_geocodes pumg1,
4206: pay_us_modified_geocodes pumg2
4207: where pgu.process_type = 'CY'
4208: and pgu.table_name = 'HR_ORGANIZATION_INFORMATION'
4209: and hoi.org_information_id = pgu.table_value_id

Line 4206: pay_us_modified_geocodes pumg2

4202: fnd_descr_flex_contexts_vl fdfv,
4203: fnd_descr_flex_col_usage_vl fdfc,
4204: hr_org_information_types hoit,
4205: pay_us_modified_geocodes pumg1,
4206: pay_us_modified_geocodes pumg2
4207: where pgu.process_type = 'CY'
4208: and pgu.table_name = 'HR_ORGANIZATION_INFORMATION'
4209: and hoi.org_information_id = pgu.table_value_id
4210: and hoi.organization_id = hou.organization_id

Line 4241: ln_old_city_name pay_us_modified_geocodes.city_name%TYPE;

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;
4244:
4245: ln_location_name hr_locations_all.location_code%TYPE;

Line 4242: ln_new_city_name pay_us_modified_geocodes.city_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;
4244:
4245: ln_location_name hr_locations_all.location_code%TYPE;
4246: ln_location_id hr_locations_all.location_id%TYPE;