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 287: FROM ben_per_in_ler pil

283:
284: CURSOR c_pil_ovn (v_per_in_ler_id IN NUMBER)
285: IS
286: SELECT object_version_number
287: FROM ben_per_in_ler pil
288: WHERE pil.per_in_ler_id = v_per_in_ler_id;
289:
290: CURSOR c_info_ovn (v_group_per_in_ler_id IN NUMBER)
291: IS

Line 326: , ben_per_in_ler pil

322: , info.business_group_id
323: FROM per_business_groups_perf bg
324: , ben_cwb_person_info info
325: , per_all_people_f per
326: , ben_per_in_ler pil
327: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id
328: AND bg.business_group_id = info.business_group_id
329: AND v_effective_date >= bg.date_from
330: AND ( bg.date_to IS NULL

Line 460: ben_per_in_ler pil,

456: , bg.NAME
457: , per.legislation_code
458: , per.business_group_id
459: FROM
460: ben_per_in_ler pil,
461: ben_per_in_ler mgr_pil,
462: ben_cwb_person_info per,
463: ben_cwb_group_hrchy hrchy,
464: per_business_groups_perf bg

Line 461: ben_per_in_ler mgr_pil,

457: , per.legislation_code
458: , per.business_group_id
459: FROM
460: ben_per_in_ler pil,
461: ben_per_in_ler mgr_pil,
462: ben_cwb_person_info per,
463: ben_cwb_group_hrchy hrchy,
464: per_business_groups_perf bg
465: where pil.per_in_ler_stat_cd = 'STRTD'

Line 510: FROM ben_per_in_ler pil

506: , max(pil.per_in_ler_id) per_in_ler_id
507: , max(nvl(per.custom_name,per.full_name)) full_name
508: , max(bg.NAME) NAME
509: , per.business_group_id
510: FROM ben_per_in_ler pil
511: , ben_per_in_ler mgr_pil
512: , ben_cwb_group_hrchy hrchy
513: , per_business_groups_perf bg
514: , ben_cwb_person_info per

Line 511: , ben_per_in_ler mgr_pil

507: , max(nvl(per.custom_name,per.full_name)) full_name
508: , max(bg.NAME) NAME
509: , per.business_group_id
510: FROM ben_per_in_ler pil
511: , ben_per_in_ler mgr_pil
512: , ben_cwb_group_hrchy hrchy
513: , per_business_groups_perf bg
514: , ben_cwb_person_info per
515: , ben_cwb_person_rates rates

Line 567: FROM ben_per_in_ler pil

563: IS
564: SELECT pil.per_in_ler_id
565: , pil.per_in_ler_stat_cd
566: , pil.object_version_number
567: FROM ben_per_in_ler pil
568: WHERE pil.group_pl_id = v_group_pl_id
569: AND pil.person_id = v_person_id
570: AND pil.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
571: AND pil.per_in_ler_stat_cd = 'STRTD'

Line 710: , ben_per_in_ler pil

706: , ben_oipl_f oipl
707: , ben_cwb_pl_dsgn dsgn
708: , ben_opt_f opt
709: , ben_cwb_person_info info
710: , ben_per_in_ler pil
711: , ben_cwb_xchg xchg
712: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
713: AND rt.pl_id = dsgn.pl_id
714: AND rt.oipl_id = dsgn.oipl_id

Line 758: , ben_per_in_ler pil

754: , ben_oipl_f oipl
755: , ben_cwb_pl_dsgn dsgn
756: , ben_opt_f opt
757: , ben_cwb_person_info info
758: , ben_per_in_ler pil
759: , ben_cwb_xchg xchg
760: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
761: AND rt.group_pl_id = v_group_pl_id
762: --AND rt.oipl_id <> -1

Line 816: , ben_per_in_ler pil

812: , rt.currency
813: FROM ben_cwb_person_rates rt
814: , ben_cwb_pl_dsgn dsgn
815: , ben_cwb_person_info info
816: , ben_per_in_ler pil
817: , ben_oipl_f oipl
818: , ben_opt_f opt
819: , ben_cwb_xchg xchg
820: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id

Line 996: FROM ben_per_in_ler pil

992: )
993: IS
994: SELECT pil.per_in_ler_id
995: ,nvl(info.custom_name,info.full_name) full_name
996: FROM ben_per_in_ler pil
997: ,ben_cwb_person_groups pgroup
998: ,ben_cwb_person_info info
999: WHERE pil.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
1000: AND pil.group_pl_id = v_group_pl_id

Line 1007: FROM ben_cwb_group_hrchy h, ben_per_in_ler p

1003: AND ( nvl(pgroup.access_cd,'UP') = 'UP' OR approval_cd = 'AP' )
1004: AND info.group_per_in_ler_id = pil.per_in_ler_id
1005: AND NOT EXISTS (
1006: SELECT NULL
1007: FROM ben_cwb_group_hrchy h, ben_per_in_ler p
1008: ,ben_cwb_person_rates r
1009: WHERE h.mgr_per_in_ler_id = pil.per_in_ler_id
1010: AND h.lvl_num > 0
1011: AND p.per_in_ler_id = h.emp_per_in_ler_id

Line 1021: FROM ben_per_in_ler p

1017: AND r.elig_flag = 'Y'
1018: )
1019: AND NOT EXISTS (
1020: SELECT NULL
1021: FROM ben_per_in_ler p
1022: WHERE p.per_in_ler_id = pil.per_in_ler_id
1023: AND p.lf_evt_ocrd_dt = pil.lf_evt_ocrd_dt
1024: AND p.group_pl_id = pil.group_pl_id
1025: AND p.per_in_ler_stat_cd = 'STRTD'

Line 1036: FROM ben_per_in_ler pil

1032:
1033: CURSOR c_emp_pils_still_open(v_mgr_per_in_ler_id IN NUMBER)
1034: IS
1035: SELECT emp_per_in_ler_id
1036: FROM ben_per_in_ler pil
1037: ,ben_cwb_group_hrchy hrchy
1038: WHERE hrchy.mgr_per_in_ler_id = v_mgr_per_in_ler_id
1039: AND hrchy.lvl_num > 0
1040: AND pil.per_in_ler_id = hrchy.emp_per_in_ler_id