APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on PAY_US_CITY_NAMES

Line 1279: pay_us_city_names pusc ,

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

Line 1518: pay_us_city_names pusc,

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
1520: where pgu.process_type = 'UP'
1521: and pgu.table_name is not null
1522: and pef.assignment_id = pgu.assignment_id

Line 1735: pay_us_city_names pusc,

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 ,
1737: pay_us_states pust,
1738: pay_us_counties puscn
1739: where pgu.process_type = 'US'

Line 1998: INDEX (PAY_US_CITY_NAMES PAY_US_CITY_NAMES_FK1)

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

Line 2004: pay_us_city_names pucn,

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

Line 2390: pay_us_city_names pusc,

2386: substr(pusc.city_name,1,30),
2387: pgu.new_juri_code
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

Line 2594: pay_us_city_names pusc,

2590: substr(pusc.city_name,1,30),
2591: pgu.new_juri_code
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

Line 3398: -- count for pay_us_city_names --

3394: lv_data_row := '' || lv_data_row || '' ;
3395:
3396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3397:
3398: -- count for pay_us_city_names --
3399:
3400: ln_row_count := 0;
3401:
3402: select count(*)

Line 3404: from pay_us_city_names;

3400: ln_row_count := 0;
3401:
3402: select count(*)
3403: into ln_row_count
3404: from pay_us_city_names;
3405:
3406: formated_static_data( 'PAY_US_CITY_NAMES'
3407: ,ln_row_count
3408: ,null

Line 3406: formated_static_data( 'PAY_US_CITY_NAMES'

3402: select count(*)
3403: into ln_row_count
3404: from pay_us_city_names;
3405:
3406: formated_static_data( 'PAY_US_CITY_NAMES'
3407: ,ln_row_count
3408: ,null
3409: ,null
3410: ,null