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_CWB_BACKOUT_POST_PROCESS dependencies on BEN_CWB_GROUP_HRCHY

Line 250: , ben_cwb_group_hrchy hrchy

246: , max(bg.NAME) NAME
247: , per.business_group_id
248: FROM ben_per_in_ler pil
249: , ben_per_in_ler mgr_pil
250: , ben_cwb_group_hrchy hrchy
251: , per_business_groups_perf bg
252: , ben_cwb_person_info per
253: , ben_cwb_person_rates rates
254: , ben_cwb_pl_dsgn dsgn

Line 271: FROM ben_cwb_group_hrchy

267: AND hrchy.emp_per_in_ler_id = pil.per_in_ler_id
268: AND hrchy.mgr_per_in_ler_id = mgr_pil.per_in_ler_id
269: AND ( ( v_manager_id IS NULL
270: AND hrchy.lvl_num = (SELECT MAX (lvl_num)
271: FROM ben_cwb_group_hrchy
272: WHERE emp_per_in_ler_id = hrchy.emp_per_in_ler_id)
273: )
274: OR ( mgr_pil.person_id = v_manager_id
275: AND hrchy.lvl_num > 0)

Line 309: ben_cwb_group_hrchy hrchy,

305: FROM
306: ben_per_in_ler pil,
307: ben_per_in_ler mgr_pil,
308: ben_cwb_person_info per,
309: ben_cwb_group_hrchy hrchy,
310: per_business_groups_perf bg
311: where pil.per_in_ler_stat_cd = 'PROCD'
312: AND pil.group_pl_id = per.group_pl_id
313: AND pil.lf_evt_ocrd_dt = per.lf_evt_ocrd_dt

Line 321: FROM ben_cwb_group_hrchy

317: AND ( v_person_id IS NULL
318: OR pil.person_id = v_person_id)
319: AND ( ( v_manager_id IS NULL
320: AND hrchy.lvl_num = (SELECT MAX (lvl_num)
321: FROM ben_cwb_group_hrchy
322: WHERE emp_per_in_ler_id = hrchy.emp_per_in_ler_id)
323: )
324: OR ( mgr_pil.person_id = v_manager_id
325: AND hrchy.lvl_num > 0)

Line 356: , ben_cwb_group_hrchy hrchy

352: SELECT distinct (mgr_per.group_per_in_ler_id) per_in_ler_id
353: , (mgr_per.full_name) full_name
354: FROM ben_per_in_ler pil
355: --, ben_per_in_ler mgr_pil
356: , ben_cwb_group_hrchy hrchy
357: --, ben_cwb_group_hrchy mgr_hrchy
358: , per_business_groups_perf bg
359: , ben_cwb_person_info per
360: , ben_cwb_person_info mgr_per

Line 357: --, ben_cwb_group_hrchy mgr_hrchy

353: , (mgr_per.full_name) full_name
354: FROM ben_per_in_ler pil
355: --, ben_per_in_ler mgr_pil
356: , ben_cwb_group_hrchy hrchy
357: --, ben_cwb_group_hrchy mgr_hrchy
358: , per_business_groups_perf bg
359: , ben_cwb_person_info per
360: , ben_cwb_person_info mgr_per
361: --, ben_cwb_person_rates rates

Line 1002: from ben_cwb_group_hrchy hrchy,

998: CURSOR c_mrg_access_change (
999: v_mgr_per_in_ler_id IN NUMBER
1000: ) IS
1001: SELECT distinct hrchy.mgr_per_in_ler_id mgr_per_in_ler_id
1002: from ben_cwb_group_hrchy hrchy,
1003: ben_per_in_ler pil
1004: where hrchy.mgr_per_in_ler_id = v_mgr_per_in_ler_id
1005: and hrchy.emp_per_in_ler_id = pil.per_in_ler_id
1006: and hrchy.lvl_num > 0