APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_LINKS_F

Line 6010: ,pay_element_links_f pel

6006: ,c_effective_date in date
6007: ,c_element_type_id in number ) Is
6008: Select pee.element_entry_id
6009: from pay_element_entries_f pee
6010: ,pay_element_links_f pel
6011: where pee.assignment_id = c_assignment_id
6012: and pel.element_link_id = pee.element_link_id
6013: and pel.element_type_id = c_element_type_id
6014: and c_effective_date between pee.effective_start_date

Line 6343: from pay_element_links_f pel

6339: p_assignment_id IN NUMBER
6340: ,p_element_type_id IN NUMBER
6341: ,p_date IN DATE )IS
6342: select 'Y'
6343: from pay_element_links_f pel
6344: ,pay_element_entries_f pee
6345: ,pay_element_types_f pet
6346: where pet.element_type_id = pel.element_type_id
6347: and pel.element_link_id = pee.element_link_id

Line 17155: FROM pay_element_links_f pel

17151: AND petei.eei_information_category ='PQP_UK_ELEMENT_ATTRIBUTION';
17152:
17153: CURSOR c_element_entry(p_element_type_id IN NUMBER) IS
17154: SELECT pee.element_entry_id
17155: FROM pay_element_links_f pel
17156: ,pay_element_entries_f pee
17157: where pel.element_type_id = p_element_type_id
17158: and p_effective_date between pel.effective_start_date
17159: and pel.effective_end_date

Line 17685: ,pay_element_links_f pel

17681: )
17682: IS
17683: SELECT 'X'
17684: FROM pay_element_entries_f pee
17685: ,pay_element_links_f pel
17686: WHERE pee.assignment_id = c_assignment_id
17687: AND pee.entry_type = 'E'
17688: AND pee.element_link_id = pel.element_link_id
17689: AND c_effective_date BETWEEN pee.effective_start_date