eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PERSON_DELETE dependencies on PAY_ELEMENT_ENTRIES_F

Line 2272: --** CN|c9|Fetch the element_entry_id from pay_element_entries_f associated with a person_id.

2268: SELECT DISTINCT elig_per_id
2269: FROM ben_elig_per_f
2270: WHERE person_id = p_person_id;
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

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