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_POST_PROCESS dependencies on BEN_PER_IN_LER

Line 276: FROM ben_per_in_ler pil

272:
273: CURSOR c_pil_ovn (v_per_in_ler_id IN NUMBER)
274: IS
275: SELECT object_version_number
276: FROM ben_per_in_ler pil
277: WHERE pil.per_in_ler_id = v_per_in_ler_id;
278:
279: CURSOR c_info_ovn (v_group_per_in_ler_id IN NUMBER)
280: IS

Line 315: , ben_per_in_ler pil

311: , info.business_group_id
312: FROM per_business_groups_perf bg
313: , ben_cwb_person_info info
314: , per_all_people_f per
315: , ben_per_in_ler pil
316: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id
317: AND bg.business_group_id = info.business_group_id
318: AND v_effective_date >= bg.date_from
319: AND ( bg.date_to IS NULL

Line 449: ben_per_in_ler pil,

445: , bg.NAME
446: , per.legislation_code
447: , per.business_group_id
448: FROM
449: ben_per_in_ler pil,
450: ben_per_in_ler mgr_pil,
451: ben_cwb_person_info per,
452: ben_cwb_group_hrchy hrchy,
453: per_business_groups_perf bg

Line 450: ben_per_in_ler mgr_pil,

446: , per.legislation_code
447: , per.business_group_id
448: FROM
449: ben_per_in_ler pil,
450: ben_per_in_ler mgr_pil,
451: ben_cwb_person_info per,
452: ben_cwb_group_hrchy hrchy,
453: per_business_groups_perf bg
454: where pil.per_in_ler_stat_cd = 'STRTD'

Line 499: FROM ben_per_in_ler pil

495: , max(pil.per_in_ler_id) per_in_ler_id
496: , max(nvl(per.custom_name,per.full_name)) full_name
497: , max(bg.NAME) NAME
498: , per.business_group_id
499: FROM ben_per_in_ler pil
500: , ben_per_in_ler mgr_pil
501: , ben_cwb_group_hrchy hrchy
502: , per_business_groups_perf bg
503: , ben_cwb_person_info per

Line 500: , ben_per_in_ler mgr_pil

496: , max(nvl(per.custom_name,per.full_name)) full_name
497: , max(bg.NAME) NAME
498: , per.business_group_id
499: FROM ben_per_in_ler pil
500: , ben_per_in_ler mgr_pil
501: , ben_cwb_group_hrchy hrchy
502: , per_business_groups_perf bg
503: , ben_cwb_person_info per
504: , ben_cwb_person_rates rates

Line 556: FROM ben_per_in_ler pil

552: IS
553: SELECT pil.per_in_ler_id
554: , pil.per_in_ler_stat_cd
555: , pil.object_version_number
556: FROM ben_per_in_ler pil
557: WHERE pil.group_pl_id = v_group_pl_id
558: AND pil.person_id = v_person_id
559: AND pil.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
560: AND pil.per_in_ler_stat_cd = 'STRTD'

Line 698: , ben_per_in_ler pil

694: , ben_oipl_f oipl
695: , ben_cwb_pl_dsgn dsgn
696: , ben_opt_f opt
697: , ben_cwb_person_info info
698: , ben_per_in_ler pil
699: , ben_cwb_xchg xchg
700: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
701: AND rt.pl_id = dsgn.pl_id
702: AND rt.oipl_id = dsgn.oipl_id

Line 746: , ben_per_in_ler pil

742: , ben_oipl_f oipl
743: , ben_cwb_pl_dsgn dsgn
744: , ben_opt_f opt
745: , ben_cwb_person_info info
746: , ben_per_in_ler pil
747: , ben_cwb_xchg xchg
748: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
749: AND rt.group_pl_id = v_group_pl_id
750: --AND rt.oipl_id <> -1

Line 804: , ben_per_in_ler pil

800: , rt.currency
801: FROM ben_cwb_person_rates rt
802: , ben_cwb_pl_dsgn dsgn
803: , ben_cwb_person_info info
804: , ben_per_in_ler pil
805: , ben_oipl_f oipl
806: , ben_opt_f opt
807: , ben_cwb_xchg xchg
808: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id

Line 983: FROM ben_per_in_ler pil

979: )
980: IS
981: SELECT pil.per_in_ler_id
982: ,nvl(info.custom_name,info.full_name) full_name
983: FROM ben_per_in_ler pil
984: ,ben_cwb_person_groups pgroup
985: ,ben_cwb_person_info info
986: WHERE pil.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
987: AND pil.group_pl_id = v_group_pl_id

Line 994: FROM ben_cwb_group_hrchy h, ben_per_in_ler p

990: AND ( nvl(pgroup.access_cd,'UP') = 'UP' OR approval_cd = 'AP' )
991: AND info.group_per_in_ler_id = pil.per_in_ler_id
992: AND NOT EXISTS (
993: SELECT NULL
994: FROM ben_cwb_group_hrchy h, ben_per_in_ler p
995: ,ben_cwb_person_rates r
996: WHERE h.mgr_per_in_ler_id = pil.per_in_ler_id
997: AND h.lvl_num > 0
998: AND p.per_in_ler_id = h.emp_per_in_ler_id

Line 1008: FROM ben_per_in_ler p

1004: AND r.elig_flag = 'Y'
1005: )
1006: AND NOT EXISTS (
1007: SELECT NULL
1008: FROM ben_per_in_ler p
1009: WHERE p.per_in_ler_id = pil.per_in_ler_id
1010: AND p.lf_evt_ocrd_dt = pil.lf_evt_ocrd_dt
1011: AND p.group_pl_id = pil.group_pl_id
1012: AND p.per_in_ler_stat_cd = 'STRTD'

Line 1023: FROM ben_per_in_ler pil

1019:
1020: CURSOR c_emp_pils_still_open(v_mgr_per_in_ler_id IN NUMBER)
1021: IS
1022: SELECT emp_per_in_ler_id
1023: FROM ben_per_in_ler pil
1024: ,ben_cwb_group_hrchy hrchy
1025: WHERE hrchy.mgr_per_in_ler_id = v_mgr_per_in_ler_id
1026: AND hrchy.lvl_num > 0
1027: AND pil.per_in_ler_id = hrchy.emp_per_in_ler_id