APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on PAY_US_STATES

Line 1373: pay_us_states pust,

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

Line 2904: -- count for pay_us_states --

2900: ************************************************************/
2901:
2902: hr_utility.set_location(gv_package_name || '.report_13', 60);
2903:
2904: -- count for pay_us_states --
2905:
2906: ln_row_count := 0;
2907:
2908: select count(*)

Line 2910: from pay_us_states;

2906: ln_row_count := 0;
2907:
2908: select count(*)
2909: into ln_row_count
2910: from pay_us_states;
2911:
2912: formated_static_data( 'PAY_US_STATES'
2913: ,ln_row_count
2914: ,null

Line 2912: formated_static_data( 'PAY_US_STATES'

2908: select count(*)
2909: into ln_row_count
2910: from pay_us_states;
2911:
2912: formated_static_data( 'PAY_US_STATES'
2913: ,ln_row_count
2914: ,null
2915: ,null
2916: ,null