APPS.PAY_CN_RULES dependencies on PAY_ELEMENT_ENTRIES_F

Line 70: FROM pay_element_entries_f pee

66: l_procedure_name VARCHAR2(255) ;
67:
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

Line 91: FROM pay_element_entries_f pee

87: AND effective_end_date;
88:
89: CURSOR csr_tax_area (p_effective_date IN DATE) IS
90: SELECT hsck.segment20, pa.business_group_id
91: FROM pay_element_entries_f pee
92: ,per_assignments_f pa
93: ,hr_soft_coding_keyflex hsck
94: WHERE pee.assignment_id = pa.assignment_id
95: AND pa.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

Line 116: l_creator_type pay_element_entries_f.creator_type%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;
117:
118: BEGIN
119: l_procedure_name := g_package_name ||'get_retro_component_id';
120: g_debug := hr_utility.debug_enabled;