APPS.PAY_IE_PAYE_API dependencies on PAY_ELEMENT_LINKS_F

Line 57: FROM pay_element_links_f links, per_all_assignments_f assign

53: --
54:
55: CURSOR link_csr(p_element_type_id IN NUMBER) IS
56: SELECT links.element_link_id
57: FROM pay_element_links_f links, per_all_assignments_f assign
58: WHERE links.element_type_id = p_element_type_id
59: AND links.business_group_id=p_business_group_id
60: AND assign.assignment_id=p_assignment_id
61: AND (( links.payroll_id is not null

Line 218: pay_element_links_f pel

214: CURSOR entry_csr IS
215: SELECT pee.element_entry_id, pee.effective_start_date, pee.object_version_number
216: FROM pay_element_entries_f pee,
217: pay_element_types_f pet,
218: pay_element_links_f pel
219: WHERE pee.element_link_id = pel.element_link_id AND
220: pee.assignment_id = p_assignment_id AND
221: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
222: --pee.effective_start_date >= l_tax_yr_start_date and

Line 243: pay_element_links_f pel

239: CURSOR entry_csr_any IS
240: SELECT pee.element_entry_id, pee.effective_start_date
241: FROM pay_element_entries_f pee,
242: pay_element_types_f pet,
243: pay_element_links_f pel
244: WHERE pee.element_link_id = pel.element_link_id AND
245: pee.assignment_id = p_assignment_id AND
246: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
247: pel.element_type_id = pet.element_type_id AND

Line 417: pay_element_links_f pel

413: CURSOR entry_csr IS
414: SELECT pee.element_entry_id, pee.effective_start_date, pee.object_version_number
415: FROM pay_element_entries_f pee,
416: pay_element_types_f pet,
417: pay_element_links_f pel
418: WHERE pee.element_link_id = pel.element_link_id AND
419: pee.assignment_id = p_assignment_id AND
420: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
421: pel.element_type_id = pet.element_type_id AND

Line 499: FROM pay_element_links_f links, per_all_assignments_f assign

495: --
496: -- BUG 2616218
497: CURSOR link_csr(p_element_type_id IN NUMBER) IS
498: SELECT links.element_link_id
499: FROM pay_element_links_f links, per_all_assignments_f assign
500: WHERE links.element_type_id = p_element_type_id
501: AND links.business_group_id=p_business_group_id
502: AND assign.assignment_id=p_assignment_id
503: AND (( links.payroll_id is not null

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

592: rather than just deleting the one.
593:
594: CURSOR entry_csr IS
595: SELECT pee.element_entry_id
596: FROM pay_element_entries_f pee, pay_element_types_f pet, pay_element_links_f pel
597: WHERE pee.element_link_id = pel.element_link_id
598: AND pee.assignment_id = p_assignment_id
599: AND p_effective_date BETWEEN pee.effective_start_Date AND pee.effective_end_Date
600: AND pel.element_type_id = pet.element_type_id

Line 615: pay_element_links_f pel

611: CURSOR entry_csr IS
612: SELECT pee.element_entry_id, pee.effective_start_date
613: FROM pay_element_entries_f pee,
614: pay_element_types_f pet,
615: pay_element_links_f pel
616: WHERE pee.element_link_id = pel.element_link_id AND
617: pee.assignment_id = p_assignment_id AND
618: pee.effective_start_date >= l_tax_yr_start_date and
619: pee.effective_end_date <= add_months(l_tax_yr_start_date,12) AND

Line 1004: pay_element_links_f pel

1000: /* CURSOR future_entry_csr IS
1001: SELECT pee.element_entry_id, pee.effective_start_date
1002: FROM pay_element_entries_f pee,
1003: pay_element_types_f pet,
1004: pay_element_links_f pel
1005: WHERE pee.element_link_id = pel.element_link_id AND
1006: pee.assignment_id = l_assignment_id AND
1007: pee.effective_start_date >= l_tax_yr_start_date and
1008: pee.effective_end_date <= add_months(l_tax_yr_start_date,12) AND