APPS.PAY_CN_RULES dependencies on PAY_ELEMENT_TYPES_F

Line 72: ,pay_element_types_f pet

68: CURSOR csr_et(p_effective_date IN DATE) IS
69: SELECT pet.element_name, pee.creator_type
70: FROM pay_element_entries_f pee
71: ,pay_element_links_f pel
72: ,pay_element_types_f pet
73: WHERE pee.element_link_id = pel.element_link_id
74: AND pel.element_type_id = pet.element_type_id
75: AND pee.element_entry_id = p_ee_id
76: AND p_effective_date BETWEEN pel.effective_start_date

Line 84: FROM pay_element_types_f

80: ORDER BY pee.effective_start_date desc;
81:
82: CURSOR csr_ename (p_effective_date IN DATE) IS
83: SELECT element_name, 'F'
84: FROM pay_element_types_f
85: WHERE element_type_id = p_element_type_id
86: AND p_effective_date BETWEEN effective_start_date
87: AND effective_end_date;
88:

Line 112: l_element_name pay_element_types_f.element_name%TYPE;

108: AND p_effective_date BETWEEN TO_DATE(org_information3,'YYYY/MM/DD HH24:MI:SS')
109: AND TO_DATE(NVL(org_information4,'4712/12/31 00:00:00'),'YYYY/MM/DD HH24:MI:SS');
110:
111: l_retro_component_id pay_retro_components.retro_component_id%TYPE;
112: l_element_name pay_element_types_f.element_name%TYPE;
113: l_tax_area hr_soft_coding_keyflex.segment20%TYPE;
114: l_bg_id per_all_assignments_f.business_group_id%TYPE;
115: l_effective_date DATE;
116: l_creator_type pay_element_entries_f.creator_type%TYPE;