APPS.PAY_IE_PAYE_API dependencies on PAY_ELEMENT_LINKS_F

Line 62: FROM pay_element_links_f links, per_all_assignments_f assign

58: --
59:
60: CURSOR link_csr(p_element_type_id IN NUMBER) IS
61: SELECT links.element_link_id
62: FROM pay_element_links_f links, per_all_assignments_f assign
63: WHERE links.element_type_id = p_element_type_id
64: AND links.business_group_id=p_business_group_id
65: AND assign.assignment_id=p_assignment_id
66: AND (( links.payroll_id is not null

Line 251: pay_element_links_f pel

247: CURSOR entry_csr IS
248: SELECT pee.element_entry_id, pee.effective_start_date, pee.object_version_number
249: FROM pay_element_entries_f pee,
250: pay_element_types_f pet,
251: pay_element_links_f pel
252: WHERE pee.element_link_id = pel.element_link_id AND
253: pee.assignment_id = p_assignment_id AND
254: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
255: --pee.effective_start_date >= l_tax_yr_start_date and

Line 276: pay_element_links_f pel

272: CURSOR entry_csr_any IS
273: SELECT pee.element_entry_id, pee.effective_start_date
274: FROM pay_element_entries_f pee,
275: pay_element_types_f pet,
276: pay_element_links_f pel
277: WHERE pee.element_link_id = pel.element_link_id AND
278: pee.assignment_id = p_assignment_id AND
279: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
280: pel.element_type_id = pet.element_type_id AND

Line 483: pay_element_links_f pel

479: CURSOR entry_csr IS
480: SELECT pee.element_entry_id, pee.effective_start_date, pee.object_version_number
481: FROM pay_element_entries_f pee,
482: pay_element_types_f pet,
483: pay_element_links_f pel
484: WHERE pee.element_link_id = pel.element_link_id AND
485: pee.assignment_id = p_assignment_id AND
486: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
487: pel.element_type_id = pet.element_type_id AND

Line 573: FROM pay_element_links_f links, per_all_assignments_f assign

569: --
570: -- BUG 2616218
571: CURSOR link_csr(p_element_type_id IN NUMBER) IS
572: SELECT links.element_link_id
573: FROM pay_element_links_f links, per_all_assignments_f assign
574: WHERE links.element_type_id = p_element_type_id
575: AND links.business_group_id=p_business_group_id
576: AND assign.assignment_id=p_assignment_id
577: AND (( links.payroll_id is not null

Line 692: FROM pay_element_entries_f pee, pay_element_types_f pet, pay_element_links_f pel

688: rather than just deleting the one.
689:
690: CURSOR entry_csr IS
691: SELECT pee.element_entry_id
692: FROM pay_element_entries_f pee, pay_element_types_f pet, pay_element_links_f pel
693: WHERE pee.element_link_id = pel.element_link_id
694: AND pee.assignment_id = p_assignment_id
695: AND p_effective_date BETWEEN pee.effective_start_Date AND pee.effective_end_Date
696: AND pel.element_type_id = pet.element_type_id

Line 711: pay_element_links_f pel

707: CURSOR entry_csr IS
708: SELECT pee.element_entry_id, pee.effective_start_date
709: FROM pay_element_entries_f pee,
710: pay_element_types_f pet,
711: pay_element_links_f pel
712: WHERE pee.element_link_id = pel.element_link_id AND
713: pee.assignment_id = p_assignment_id AND
714: pee.effective_start_date >= l_tax_yr_start_date and
715: pee.effective_end_date <= add_months(l_tax_yr_start_date,12) AND

Line 1316: pay_element_links_f pel

1312: /* CURSOR future_entry_csr IS
1313: SELECT pee.element_entry_id, pee.effective_start_date
1314: FROM pay_element_entries_f pee,
1315: pay_element_types_f pet,
1316: pay_element_links_f pel
1317: WHERE pee.element_link_id = pel.element_link_id AND
1318: pee.assignment_id = l_assignment_id AND
1319: pee.effective_start_date >= l_tax_yr_start_date and
1320: pee.effective_end_date <= add_months(l_tax_yr_start_date,12) AND