DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_ELEMENT_LINKS_F

Line 862: pay_element_links_f pelf

858: CURSOR C_ELEMENT_TYPE_ID
859: IS
860: SELECT pelf.element_type_id
861: FROM pay_element_entries_f peef ,
862: pay_element_links_f pelf
863: WHERE pelf.element_link_id = peef.element_link_id
864: AND peef.element_entry_id = P_ELEM_ENTRY_ID
865: AND g_payroll_end_date BETWEEN peef.effective_start_date AND peef.effective_end_date
866: AND g_payroll_end_date BETWEEN pelf.effective_start_date AND pelf.effective_end_date;