APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on PAY_US_STATES

Line 1737: pay_us_states pust,

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

Line 3315: -- count for pay_us_states --

3311: ************************************************************/
3312:
3313: hr_utility.set_location(gv_package_name || '.report_13', 60);
3314:
3315: -- count for pay_us_states --
3316:
3317: ln_row_count := 0;
3318:
3319: select count(*)

Line 3321: from pay_us_states;

3317: ln_row_count := 0;
3318:
3319: select count(*)
3320: into ln_row_count
3321: from pay_us_states;
3322:
3323: formated_static_data( 'PAY_US_STATES'
3324: ,ln_row_count
3325: ,null

Line 3323: formated_static_data( 'PAY_US_STATES'

3319: select count(*)
3320: into ln_row_count
3321: from pay_us_states;
3322:
3323: formated_static_data( 'PAY_US_STATES'
3324: ,ln_row_count
3325: ,null
3326: ,null
3327: ,null

Line 4070: pay_us_states pus,

4066: pumg1.city_name old_city_name,
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