APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_US_ZIP_CODES

Line 230: FROM pay_us_zip_codes puzc

226:
227: CURSOR get_resident_zip_code(cp_jurisdiction_code VARCHAR2)
228: IS
229: SELECT MIN(puzc.zip_start)
230: FROM pay_us_zip_codes puzc
231: WHERE puzc.state_code = SUBSTR(cp_jurisdiction_code,1,2)
232: AND puzc.county_code = SUBSTR(cp_jurisdiction_code,4,3)
233: AND puzc.city_code = SUBSTR(cp_jurisdiction_code,8,4);
234:

Line 350: lv_resident_zip_code pay_us_zip_codes.zip_start%TYPE;

346:
347: lv_resident_state pay_us_states.state_abbrev%TYPE;
348: lv_resident_county pay_us_counties.county_name%TYPE;
349: lv_resident_city pay_us_city_names.city_name%TYPE;
350: lv_resident_zip_code pay_us_zip_codes.zip_start%TYPE;
351:
352: lv_datetrack_update_mode VARCHAR2(50) := 'CORRECTION';
353: ln_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
354: ln_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;