DBA Data[Home] [Help]

APPS.BEN_PERSON_DELETE dependencies on PER_ALL_ASSIGNMENTS_F

Line 2275: FROM per_all_assignments_f paf, pay_element_entries_f pee

2271: --** C|c9
2272: --** CN|c9|Fetch the element_entry_id from pay_element_entries_f associated with a person_id.
2273: CURSOR c9 IS
2274: SELECT DISTINCT element_entry_id
2275: FROM per_all_assignments_f paf, pay_element_entries_f pee
2276: WHERE paf.person_id = p_person_id
2277: AND pee.assignment_id = paf.assignment_id;
2278: CURSOR c20 (
2279: p_person_id NUMBER