APPS.PAY_FI_EXPIRY_SUPPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 131: per_all_assignments_f paf1,

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'
135: and pet.legislation_code='FI'

Line 132: per_all_assignments_f paf2,

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'
135: and pet.legislation_code='FI'
136: and pet.element_type_id=pee.element_type_id

Line 267: per_all_assignments_f paf1,

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'
271: and pet.legislation_code='FI'

Line 268: per_all_assignments_f paf2,

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'
271: and pet.legislation_code='FI'
272: and pet.element_type_id=pee.element_type_id