APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on PAY_US_CITY_NAMES

Line 915: pay_us_city_names pusc ,

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,
919: pay_us_geo_update pgu

Line 1154: pay_us_city_names pusc,

1150: substr(table_name,1,20)
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

Line 1371: pay_us_city_names pusc,

1367: new_juri_code
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'

Line 1634: INDEX (PAY_US_CITY_NAMES PAY_US_CITY_NAMES_FK1)

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),
1638: SUBSTR(pucn.city_name,1,20)

Line 1640: pay_us_city_names pucn,

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
1644: WHERE pmod.process_type = 'P'

Line 1658: INDEX (PAY_US_CITY_NAMES PAY_US_CITY_NAMES_FK1)

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),
1662: SUBSTR(pmod.city_name,1,20)

Line 1664: pay_us_city_names pucn,

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,
1668: hr_s_us_city_names pmod2

Line 2028: pay_us_city_names pusc,

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
2031: where pgu.process_type = 'NEW_CITY_RECORDS'
2032: and pef.assignment_id = pgu.assignment_id

Line 2232: pay_us_city_names pusc,

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
2235: where pgu.process_type = 'NEW_VERTEX_RECORDS'
2236: and pef.assignment_id = pgu.assignment_id

Line 2987: -- count for pay_us_city_names --

2983: lv_data_row := '' || lv_data_row || '' ;
2984:
2985: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2986:
2987: -- count for pay_us_city_names --
2988:
2989: ln_row_count := 0;
2990:
2991: select count(*)

Line 2993: from pay_us_city_names;

2989: ln_row_count := 0;
2990:
2991: select count(*)
2992: into ln_row_count
2993: from pay_us_city_names;
2994:
2995: formated_static_data( 'PAY_US_CITY_NAMES'
2996: ,ln_row_count
2997: ,null

Line 2995: formated_static_data( 'PAY_US_CITY_NAMES'

2991: select count(*)
2992: into ln_row_count
2993: from pay_us_city_names;
2994:
2995: formated_static_data( 'PAY_US_CITY_NAMES'
2996: ,ln_row_count
2997: ,null
2998: ,null
2999: ,null