APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_US_STATES

Line 295: pay_us_states pus

291: IS
292: SELECT pst.emp_state_tax_rule_id,
293: pst.object_version_number
294: FROM pay_us_emp_state_tax_rules_f pst,
295: pay_us_states pus
296: WHERE pst.assignment_id = cp_assignment_id
297: AND cp_effective_date BETWEEN pst.effective_start_date
298: AND pst.effective_end_date
299: AND pst.state_code = pus.state_code

Line 347: lv_resident_state pay_us_states.state_abbrev%TYPE;

343: lv_resident_jd_code VARCHAR2(11);
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:

Line 575: FROM pay_us_states pus

571: to update the address */
572:
573: SELECT pus.state_abbrev
574: INTO lv_resident_state
575: FROM pay_us_states pus
576: WHERE pus.state_code = lct_region1.aei_information1;
577:
578: SELECT puc.county_name
579: INTO lv_resident_county

Line 806: FROM pay_us_states pus

802: END IF; /* lv_rs_state_changed = 'Y' IF */
803:
804: SELECT pus.state_abbrev
805: INTO lv_resident_state
806: FROM pay_us_states pus
807: WHERE pus.state_code = lct_region1.aei_information1;
808:
809: OPEN get_location_state(lct_region1.aei_information4);
810: FETCH get_location_state INTO lv_work_state;

Line 1190: FROM pay_us_states pus,

1186: CURSOR c_get_emp_res_jd(cp_state_abbrev VARCHAR2,
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

Line 2235: ,pay_us_states pus

2231: ,cp_legislation_code VARCHAR2)
2232: IS
2233: SELECT pus.state_code || '-000-0000'
2234: FROM per_addresses pa
2235: ,pay_us_states pus
2236: WHERE pa.person_id = cp_person_id
2237: AND pa.primary_flag = 'Y'
2238: AND cp_effective_date BETWEEN pa.date_from
2239: AND NVL(pa.date_to, hr_general.END_OF_TIME)

Line 2265: pay_us_states pus,

2261: || '-'
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