APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_US_COUNTIES

Line 348: lv_resident_county pay_us_counties.county_name%TYPE;

344:
345: lct_address_details get_address_details%ROWTYPE;
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';

Line 580: FROM pay_us_counties puc

576: WHERE pus.state_code = lct_region1.aei_information1;
577:
578: SELECT puc.county_name
579: INTO lv_resident_county
580: FROM pay_us_counties puc
581: WHERE puc.state_code = lct_region1.aei_information1
582: AND puc.county_code = SUBSTR(lct_region1.aei_information2,4,3);
583:
584: lv_resident_city := SUBSTR(lct_region1.aei_information3,13);

Line 1191: pay_us_counties puc,

1187: cp_county_name VARCHAR2,
1188: cp_city_name VARCHAR2) IS
1189: SELECT pcn.state_code||'-'||pcn.county_code||'-'||pcn.city_code
1190: FROM pay_us_states pus,
1191: pay_us_counties puc,
1192: pay_us_city_names pcn
1193: WHERE pus.state_abbrev = cp_state_abbrev
1194: AND puc.state_code = pus.state_code
1195: AND puc.county_name = cp_county_name

Line 2266: pay_us_counties puc,

2262: || punc.city_code
2263: FROM per_all_assignments_f peaf,
2264: hr_locations_all hla,
2265: pay_us_states pus,
2266: pay_us_counties puc,
2267: pay_us_city_names punc
2268: WHERE peaf.assignment_id = p_assignment_id
2269: AND peaf.location_id = hla.location_id
2270: AND hla.region_2 = pus.state_abbrev