APPS.PAY_CA_EMP_TAX_INF dependencies on HR_LOCATIONS

Line 37: HR_LOCATIONS hrl,

33: cursor csr_get_work_province is
34: select lkp.lookup_code,
35: lkp.meaning
36: from PER_ASSIGNMENTS_F paf,
37: HR_LOCATIONS hrl,
38: HR_LOOKUPS lkp
39: where paf.assignment_id = p_assignment_id
40: and p_session_date between paf.effective_start_date and
41: paf.effective_end_date

Line 426: hr_locations hl,

422:
423: CURSOR csr_get_default_province IS
424: select pcp.province_abbrev, '70-'||pcp.province_code||'-0000' geocode
425: from per_assignments_f paf,
426: hr_locations hl,
427: pay_ca_provinces_v pcp
428: where paf.assignment_id = p_assignment_id
429: and p_effective_date between paf.effective_start_date
430: and paf.effective_end_date

Line 1277: hr_locations_all hla

1273:
1274: cursor csr_get_current_location(l_asst_id in number,l_cur_date in date) is
1275: select hla.region_1
1276: from per_all_assignments_f paf,
1277: hr_locations_all hla
1278: where paf.assignment_id = l_asst_id
1279: and l_cur_date between paf.EFFECTIVE_START_DATE and paf.EFFECTIVE_END_DATE
1280: and hla.location_id = paf.location_id;
1281:

Line 1288: hr_locations_all hla

1284: from pay_run_results prr,
1285: pay_assignment_actions paa,
1286: pay_payroll_actions ppa,
1287: per_all_assignments_f paf,
1288: hr_locations_all hla
1289: where prr.run_result_id = l_run_result_id
1290: and prr.assignment_action_id = paa.assignment_action_id
1291: and paa.payroll_action_id = ppa.payroll_action_id
1292: and paf.assignment_id = paa.assignment_id

Line 1301: hr_locations_all hla

1297: select ppa.effective_date,hla.region_1
1298: from pay_assignment_actions paa,
1299: pay_payroll_actions ppa,
1300: per_all_assignments_f paf,
1301: hr_locations_all hla
1302: where paa.assignment_action_id = l_asg_action_id
1303: and ppa.payroll_action_id = paa.payroll_action_id
1304: and paf.assignment_id = paa.assignment_id
1305: and ppa.effective_date between paf.EFFECTIVE_START_DATE and paf.EFFECTIVE_END_DATE