APPS.BEN_CWB_POST_PROCESS dependencies on BEN_CWB_GROUP_HRCHY

Line 463: ben_cwb_group_hrchy hrchy,

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

Line 475: FROM ben_cwb_group_hrchy

471: AND ( v_person_id IS NULL
472: OR pil.person_id = v_person_id)
473: AND ( ( v_manager_id IS NULL
474: AND hrchy.lvl_num = (SELECT MAX (lvl_num)
475: FROM ben_cwb_group_hrchy
476: WHERE emp_per_in_ler_id = hrchy.emp_per_in_ler_id)
477: )
478: OR ( mgr_pil.person_id = v_manager_id
479: AND hrchy.lvl_num > 0)

Line 512: , ben_cwb_group_hrchy hrchy

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

Line 533: FROM ben_cwb_group_hrchy

529: AND hrchy.emp_per_in_ler_id = pil.per_in_ler_id
530: AND hrchy.mgr_per_in_ler_id = mgr_pil.per_in_ler_id
531: AND ( ( v_manager_id IS NULL
532: AND hrchy.lvl_num = (SELECT MAX (lvl_num)
533: FROM ben_cwb_group_hrchy
534: WHERE emp_per_in_ler_id = hrchy.emp_per_in_ler_id)
535: )
536: OR ( mgr_pil.person_id = v_manager_id
537: AND hrchy.lvl_num > 0)

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

1024: AND p.group_pl_id = pil.group_pl_id
1025: AND p.per_in_ler_stat_cd = 'STRTD'
1026: AND NOT EXISTS (
1027: SELECT NULL
1028: FROM ben_cwb_group_hrchy h
1029: WHERE h.mgr_per_in_ler_id = p.per_in_ler_id
1030: )
1031: );
1032:

Line 1037: ,ben_cwb_group_hrchy hrchy

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