DBA Data[Home] [Help]

APPS.PAY_FI_EXPIRY_SUPPORT dependencies on PAY_ELEMENT_TYPES_F

Line 130: pay_element_types_f pet,

126:
127: CURSOR get_element_entry_id(p_owner_assignment_action_id NUMBER, p_business_group_id NUMBER ,p_owner_effective_date DATE) is
128: select pee.element_entry_id
129: from pay_element_entries_f pee,
130: pay_element_types_f pet,
131: per_all_assignments_f paf1,
132: per_all_assignments_f paf2,
133: pay_assignment_actions paa1
134: where pet.element_name='Court Order Information'

Line 266: pay_element_types_f pet,

262: --
263: CURSOR get_element_entry_id(p_owner_assignment_action_id NUMBER, p_business_group_id NUMBER ,p_owner_effective_date DATE) is
264: select pee.element_entry_id , pee.effective_end_date
265: from pay_element_entries_f pee,
266: pay_element_types_f pet,
267: per_all_assignments_f paf1,
268: per_all_assignments_f paf2,
269: pay_assignment_actions paa1
270: where pet.element_name='Court Order Information'