APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on PAY_US_MODIFIED_GEOCODES

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

901: cursor c_cursor ( cp_process_mode in varchar
902: ,cp_geocode_patch_name in varchar
903: ) is
904:
905: select /*+ index(pmod PAY_US_MODIFIED_GEOCODES_PK)*/ -- Bug 3350007
906: distinct substr(ppf.full_name,1,40) ,
907: pef.assignment_id ,
908: substr(pef.assignment_number,1,17),
909: pgu.new_juri_code ,

Line 914: from pay_us_modified_geocodes pmod,

910: substr(pusc.city_name,1,20),
911: pgu.old_juri_code,
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,

Line 1633: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1)

1629: ,cp_geocode_patch_name in varchar
1630: ) is
1631:
1632: SELECT /*+ ORDERED
1633: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1)
1634: INDEX (PAY_US_CITY_NAMES PAY_US_CITY_NAMES_FK1)
1635: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */
1636: SUBSTR(ppf.full_name,1,40),
1637: SUBSTR(pmod.city_name,1,20),

Line 1639: FROM pay_us_modified_geocodes pmod,

1635: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */
1636: SUBSTR(ppf.full_name,1,40),
1637: SUBSTR(pmod.city_name,1,20),
1638: SUBSTR(pucn.city_name,1,20)
1639: FROM pay_us_modified_geocodes pmod,
1640: pay_us_city_names pucn,
1641: pay_us_emp_city_tax_rules_f ectr,
1642: per_assignments_f paf,
1643: per_people_f ppf

Line 1657: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1)

1653: AND paf.person_id = ppf.person_id
1654: AND pmod.patch_name = cp_geocode_patch_name
1655: union all
1656: SELECT /*+ ORDERED
1657: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1)
1658: INDEX (PAY_US_CITY_NAMES PAY_US_CITY_NAMES_FK1)
1659: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */
1660: SUBSTR(ppf.full_name,1,40),
1661: SUBSTR(pucn.city_name,1,20),

Line 1663: FROM pay_us_modified_geocodes pmod,

1659: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */
1660: SUBSTR(ppf.full_name,1,40),
1661: SUBSTR(pucn.city_name,1,20),
1662: SUBSTR(pmod.city_name,1,20)
1663: FROM pay_us_modified_geocodes pmod,
1664: pay_us_city_names pucn,
1665: pay_us_emp_city_tax_rules_f ectr,
1666: per_assignments_f paf,
1667: per_people_f ppf,

Line 1854: from pay_us_modified_geocodes

1850:
1851: select state_code||'-'||county_code||'-'||old_city_code ,
1852: state_code||'-'||county_code||'-'||new_city_code ,
1853: substr(city_name,1,20)
1854: from pay_us_modified_geocodes
1855: where old_city_code like 'U%';
1856:
1857:
1858: ln_old_juri_code varchar2(11);

Line 2592: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1) */

2588: ,cp_geocode_patch_name in varchar
2589: ) is
2590:
2591: SELECT /*+ ORDERED
2592: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1) */
2593: distinct
2594: substr(ppf.full_name,1,40),
2595: paf.assignment_id ,
2596: substr(paf.assignment_number,1,17),

Line 2602: FROM pay_us_modified_geocodes pmod,

2598: ectr.jurisdiction_code,
2599: substr(puc1.county_name,1,20),
2600: pmod.state_code||'-'||pmod.new_county_code||'-'||pmod.new_city_code "New JD",
2601: substr(puc2.county_name,1,20)
2602: FROM pay_us_modified_geocodes pmod,
2603: pay_us_emp_city_tax_rules_f ectr,
2604: per_assignments_f paf,
2605: per_people_f ppf,
2606: pay_us_counties puc1,

Line 3041: -- count for pay_us_modified_geocodes --

3037: lv_data_row := '' || lv_data_row || '' ;
3038:
3039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3040:
3041: -- count for pay_us_modified_geocodes --
3042:
3043: ln_row_count := 0;
3044:
3045: select count(*)

Line 3047: from pay_us_modified_geocodes;

3043: ln_row_count := 0;
3044:
3045: select count(*)
3046: into ln_row_count
3047: from pay_us_modified_geocodes;
3048:
3049: formated_static_data( 'PAY_US_MODIFIED_GEOCODES'
3050: ,ln_row_count
3051: ,null

Line 3049: formated_static_data( 'PAY_US_MODIFIED_GEOCODES'

3045: select count(*)
3046: into ln_row_count
3047: from pay_us_modified_geocodes;
3048:
3049: formated_static_data( 'PAY_US_MODIFIED_GEOCODES'
3050: ,ln_row_count
3051: ,null
3052: ,null
3053: ,null