APPS.BEN_CWB_POST_PROCESS dependencies on BEN_CWB_GROUP_HRCHY

Line 452: ben_cwb_group_hrchy hrchy,

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'
455: AND pil.group_pl_id = per.group_pl_id
456: AND pil.lf_evt_ocrd_dt = per.lf_evt_ocrd_dt

Line 464: FROM ben_cwb_group_hrchy

460: AND ( v_person_id IS NULL
461: OR pil.person_id = v_person_id)
462: AND ( ( v_manager_id IS NULL
463: AND hrchy.lvl_num = (SELECT MAX (lvl_num)
464: FROM ben_cwb_group_hrchy
465: WHERE emp_per_in_ler_id = hrchy.emp_per_in_ler_id)
466: )
467: OR ( mgr_pil.person_id = v_manager_id
468: AND hrchy.lvl_num > 0)

Line 501: , ben_cwb_group_hrchy hrchy

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
505: , ben_cwb_pl_dsgn dsgn

Line 522: FROM ben_cwb_group_hrchy

518: AND hrchy.emp_per_in_ler_id = pil.per_in_ler_id
519: AND hrchy.mgr_per_in_ler_id = mgr_pil.per_in_ler_id
520: AND ( ( v_manager_id IS NULL
521: AND hrchy.lvl_num = (SELECT MAX (lvl_num)
522: FROM ben_cwb_group_hrchy
523: WHERE emp_per_in_ler_id = hrchy.emp_per_in_ler_id)
524: )
525: OR ( mgr_pil.person_id = v_manager_id
526: AND hrchy.lvl_num > 0)

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 1015: FROM ben_cwb_group_hrchy h

1011: AND p.group_pl_id = pil.group_pl_id
1012: AND p.per_in_ler_stat_cd = 'STRTD'
1013: AND NOT EXISTS (
1014: SELECT NULL
1015: FROM ben_cwb_group_hrchy h
1016: WHERE h.mgr_per_in_ler_id = p.per_in_ler_id
1017: )
1018: );
1019:

Line 1024: ,ben_cwb_group_hrchy hrchy

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
1028: AND pil.per_in_ler_stat_cd = 'STRTD'