APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on PAY_US_COUNTIES

Line 1374: pay_us_counties puscn

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'
1376: and pgu.status = 'A'
1377: and pgu.table_name is null
1378: and pef.assignment_id = pgu.assignment_id

Line 2606: pay_us_counties puc1,

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,
2607: pay_us_counties puc2
2608: WHERE ppf.person_id = paf.person_id
2609: AND pmod.state_code = ectr.state_code
2610: AND pmod.state_code = puc1.state_code

Line 2607: pay_us_counties puc2

2603: pay_us_emp_city_tax_rules_f ectr,
2604: per_assignments_f paf,
2605: per_people_f ppf,
2606: pay_us_counties puc1,
2607: pay_us_counties puc2
2608: WHERE ppf.person_id = paf.person_id
2609: AND pmod.state_code = ectr.state_code
2610: AND pmod.state_code = puc1.state_code
2611: AND pmod.state_code = puc2.state_code

Line 2932: -- count for pay_us_counties --

2928: lv_data_row := '' || lv_data_row || '' ;
2929:
2930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2931:
2932: -- count for pay_us_counties --
2933:
2934: ln_row_count := 0;
2935:
2936: select count(*)

Line 2938: from pay_us_counties;

2934: ln_row_count := 0;
2935:
2936: select count(*)
2937: into ln_row_count
2938: from pay_us_counties;
2939:
2940: formated_static_data( 'PAY_US_COUNTIES'
2941: ,ln_row_count
2942: ,null

Line 2940: formated_static_data( 'PAY_US_COUNTIES'

2936: select count(*)
2937: into ln_row_count
2938: from pay_us_counties;
2939:
2940: formated_static_data( 'PAY_US_COUNTIES'
2941: ,ln_row_count
2942: ,null
2943: ,null
2944: ,null