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_PER_IN_LER

Line 129: FROM ben_per_in_ler pil

125: AND lf_evt_ocrd_dt = v_lf_evt_ocrd_date;
126: CURSOR c_pil_ovn (v_per_in_ler_id IN NUMBER)
127: IS
128: SELECT object_version_number
129: FROM ben_per_in_ler pil
130: WHERE pil.per_in_ler_id = v_per_in_ler_id;
131:
132: CURSOR c_info_ovn (v_group_per_in_ler_id IN NUMBER)
133: IS

Line 174: , ben_per_in_ler pil

170: , info.business_group_id
171: FROM per_business_groups_perf bg
172: , ben_cwb_person_info info
173: , per_all_people_f per
174: , ben_per_in_ler pil
175: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id
176: AND bg.business_group_id = info.business_group_id
177: AND v_effective_date >= bg.date_from
178: AND ( bg.date_to IS NULL

Line 248: FROM ben_per_in_ler pil

244: , max(pil.per_in_ler_id) per_in_ler_id
245: , max(nvl(per.custom_name,per.full_name)) full_name
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

Line 249: , ben_per_in_ler mgr_pil

245: , max(nvl(per.custom_name,per.full_name)) full_name
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

Line 306: ben_per_in_ler pil,

302: , bg.NAME
303: , per.legislation_code
304: , per.business_group_id
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

Line 307: ben_per_in_ler mgr_pil,

303: , per.legislation_code
304: , per.business_group_id
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'

Line 354: FROM ben_per_in_ler pil

350: )
351: IS
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

Line 355: --, ben_per_in_ler mgr_pil

351: IS
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

Line 380: OR hrchy.emp_per_in_ler_id in ( select mmgr.per_in_ler_id from ben_per_in_ler mmgr where

376: AND hrchy.lvl_num > 0
377: AND mgr_per.group_per_in_ler_id = hrchy.mgr_per_in_ler_id
378: AND ( ( v_manager_id IS NULL
379: )
380: OR hrchy.emp_per_in_ler_id in ( select mmgr.per_in_ler_id from ben_per_in_ler mmgr where
381: mmgr.ws_mgr_id = v_manager_id and mmgr.per_in_ler_stat_cd = 'PROCD')
382: )
383: /*AND rates.group_per_in_ler_id = pil.per_in_ler_id
384: AND rates.pl_id = dsgn.pl_id

Line 414: FROM ben_per_in_ler pil

410: IS
411: SELECT pil.per_in_ler_id
412: , pil.per_in_ler_stat_cd
413: , pil.object_version_number
414: FROM ben_per_in_ler pil
415: WHERE pil.group_pl_id = v_group_pl_id
416: AND pil.person_id = v_person_id
417: AND pil.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
418: AND pil.per_in_ler_stat_cd = 'PROCD'

Line 722: , ben_per_in_ler pil

718: , ben_oipl_f oipl
719: , ben_cwb_pl_dsgn dsgn
720: , ben_opt_f opt
721: , ben_cwb_person_info info
722: , ben_per_in_ler pil
723: , ben_cwb_xchg xchg
724: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
725: AND rt.group_pl_id = v_group_pl_id
726: --AND rt.oipl_id <> -1

Line 782: , ben_per_in_ler pil

778: , rt.comp_posting_date
779: FROM ben_cwb_person_rates rt
780: , ben_cwb_pl_dsgn dsgn
781: , ben_cwb_person_info info
782: , ben_per_in_ler pil
783: , ben_oipl_f oipl
784: , ben_opt_f opt
785: , ben_cwb_xchg xchg
786: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id

Line 1003: ben_per_in_ler pil

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
1007: and pil.per_in_ler_stat_cd = 'STRTD'