APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on PAY_US_COUNTIES

Line 1738: pay_us_counties puscn

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'
1740: and pgu.status = 'A'
1741: and pgu.table_name is null
1742: and pef.assignment_id = pgu.assignment_id

Line 2968: pay_us_counties puc1,

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
2972: AND pmod.state_code = puc1.state_code

Line 2969: pay_us_counties puc2

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
2972: AND pmod.state_code = puc1.state_code
2973: AND pmod.state_code = puc2.state_code

Line 3343: -- count for pay_us_counties --

3339: lv_data_row := '' || lv_data_row || '' ;
3340:
3341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3342:
3343: -- count for pay_us_counties --
3344:
3345: ln_row_count := 0;
3346:
3347: select count(*)

Line 3349: from pay_us_counties;

3345: ln_row_count := 0;
3346:
3347: select count(*)
3348: into ln_row_count
3349: from pay_us_counties;
3350:
3351: formated_static_data( 'PAY_US_COUNTIES'
3352: ,ln_row_count
3353: ,null

Line 3351: formated_static_data( 'PAY_US_COUNTIES'

3347: select count(*)
3348: into ln_row_count
3349: from pay_us_counties;
3350:
3351: formated_static_data( 'PAY_US_COUNTIES'
3352: ,ln_row_count
3353: ,null
3354: ,null
3355: ,null

Line 4071: pay_us_counties puc

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
4074: AND pus.state_code = pumg2.state_code
4075: AND puc.county_code = pumg1.county_code