APPS.PAY_DK_RULES dependencies on PAY_ELEMENT_TYPES

Line 16: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

12: (p_asg_act_id IN NUMBER
13: ,p_ee_id IN NUMBER
14: ,p_third_party_id IN OUT NOCOPY NUMBER )
15: IS
16: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
17: /* Added effective date */
18: l_effective_date DATE;
19: /* Added for pension changes */
20: l_ele_type_id NUMBER;

Line 27: FROM pay_element_types pet

23: /* Modified cursors to use effective date join */
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