APPS.PAY_IE_PAYE_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 216: FROM pay_element_entries_f pee,

212: --
213: l_tax_yr_start_date date;
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

Line 241: FROM pay_element_entries_f pee,

237: --
238: /*
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

Line 415: FROM pay_element_entries_f pee,

411: l_tax_yr_start_date date;
412: -- eff date condition is not used since we are not keeping the datetrack records.
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

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 613: FROM pay_element_entries_f pee,

609: -- entry_rec entry_csr%ROWTYPE;
610: l_tax_yr_start_date date;
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

Line 1002: FROM pay_element_entries_f pee,

998: -- Checking if any future record exist for p45 record with in the Year.
999: l_tax_yr_start_date date;
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

Line 1025: pay_element_entries_f peef

1021: pay_assignment_actions paa,
1022: pay_run_results prr,
1023: pay_run_result_values prrv,
1024: pay_element_types_f petf,
1025: pay_element_entries_f peef
1026: where ppa.business_group_id = l_business_group_id
1027: and ppa.action_type = 'B'
1028: and ppa.action_status = 'C'
1029: and ppa.payroll_action_id = paa.payroll_action_id