APPS.PAY_CA_EMP_TAX_INF dependencies on PER_ALL_ASSIGNMENTS_F

Line 1276: from per_all_assignments_f paf,

1272: where element_entry_id = p_element_entry_id;
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;

Line 1287: per_all_assignments_f paf,

1283: select ppa.effective_date,hla.region_1
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

Line 1300: per_all_assignments_f paf,

1296: cursor csr_get_orig_date_asgact(l_asg_action_id in number) is
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