APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on HR_LOCATIONS

Line 224: FROM hr_locations_all hl

220:
221: CURSOR get_location_state(cp_location_id NUMBER)
222: IS
223: SELECT NVL(hl.loc_information17,hl.region_2)
224: FROM hr_locations_all hl
225: WHERE hl.location_id = cp_location_id;
226:
227: CURSOR get_resident_zip_code(cp_jurisdiction_code VARCHAR2)
228: IS

Line 332: lv_override_location_id hr_locations_all.location_id%TYPE := NULL;

328:
329: lv_resident_addr_changed VARCHAR2(2) := 'N';
330: lv_work_location_changed VARCHAR2(2) := 'N';
331: lv_work_at_home_changed VARCHAR2(2) := 'N';
332: lv_override_location_id hr_locations_all.location_id%TYPE := NULL;
333:
334: lv_federal_tax_changed VARCHAR2(2) := 'N';
335: lv_rs_state_tax_changed VARCHAR2(2) := 'N';
336: lv_wk_state_tax_changed VARCHAR2(2) := 'N';

Line 1335: from hr_locations hl,

1331: psps.effective_end_date;
1332:
1333: CURSOR er_phone_number(cp_organization_id in number) IS
1334: select telephone_number_1
1335: from hr_locations hl,
1336: hr_organization_units hou
1337: where hou.organization_id = cp_organization_id
1338: and hou.location_id = hl.location_id;
1339:

Line 2264: hr_locations_all hla,

2260: || puc.county_code
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

Line 4043: ' SELECT NVL((select lei_information13 from hr_location_extra_info hle ,HR_LOCATIONS_ALL HLA '||

4039:
4040: build_sql(sqlstr, l_cntr_sql, 'lt_pay_date := csr_get_sim_arch_info_rec.effective_date;');
4041:
4042: build_sql(sqlstr,l_cntr_sql,
4043: ' SELECT NVL((select lei_information13 from hr_location_extra_info hle ,HR_LOCATIONS_ALL HLA '||
4044: 'WHERE hle.information_type = ''HR_SELF_SERVICE_LOC_PREFERENCE''');
4045:
4046: build_sql(sqlstr,l_cntr_sql,
4047: 'AND hle.lei_information1 =''PAYSLIP'' AND hla.LOCATION_ID = hle.LOCATION_ID AND '||