DBA Data[Home] [Help]

APPS.BEN_PERSON_DELETE dependencies on PER_ALL_ASSIGNMENTS_F

Line 2346: FROM per_all_assignments_f paf, pay_element_entries_f pee

2342: --** C|c9
2343: --** CN|c9|Fetch the element_entry_id from pay_element_entries_f associated with a person_id.
2344: CURSOR c9 IS
2345: SELECT DISTINCT element_entry_id
2346: FROM per_all_assignments_f paf, pay_element_entries_f pee
2347: WHERE paf.person_id = p_person_id
2348: AND pee.assignment_id = paf.assignment_id;
2349: CURSOR c20 (
2350: p_person_id NUMBER