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 2343: --** CN|c9|Fetch the element_entry_id from pay_element_entries_f associated with a person_id.

2339: FROM ben_elig_per_f
2340: WHERE person_id = p_person_id
2341: and per_in_ler_id = nvl(p_per_in_ler_id,per_in_ler_id);
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

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

Line 3419: pay_element_entries_f ele

3415: ben_per_in_ler pil,
3416: ben_ler_f ler,
3417: ben_prtt_rt_val prv,
3418: pay_element_entry_values_f elv,
3419: pay_element_entries_f ele
3420: where pen.person_id = p_person_id
3421: and pen.business_group_id = p_business_group_id
3422: and pen.per_in_ler_id = pil.per_in_ler_id
3423: and pen.prtt_enrt_rslt_stat_cd is null