APPS.PAY_DK_RULES dependencies on PAY_ELEMENT_ENTRIES

Line 28: , pay_element_entries pee

24: /* Modified for pension changes to fetch element_type_id also */
25: CURSOR get_element_name(p_ee_id NUMBER , p_effective_date DATE ) IS
26: SELECT pet.element_name , pet.element_type_id
27: FROM pay_element_types pet
28: , pay_element_entries pee
29: WHERE pee.element_entry_id = p_ee_id
30: AND pee.element_type_id = pet.element_type_id
31: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
32: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date;