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_SUMMARY_PKG dependencies on BEN_CWB_PERSON_GROUPS

Line 850: ,ben_cwb_person_groups grp

846: ws_bdgt_val_direct
847: ,sum(grp.ws_bdgt_iss_val * summ.elig_sal_val_direct / 100)
848: ws_bdgt_iss_val_direct
849: from ben_cwb_group_hrchy hrchy
850: ,ben_cwb_person_groups grp
851: ,ben_cwb_person_info info
852: ,ben_cwb_summary summ
853: where info.group_pl_id = p_group_pl_id
854: and info.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 876: ,ben_cwb_person_groups grp

872: grp.dist_bdgt_val)) bdgt_val_direct
873: ,sum(decode(nvl(grp.dist_bdgt_val,0),0, grp.ws_bdgt_iss_val,
874: grp.dist_bdgt_iss_val)) bdgt_iss_val_direct
875: from ben_cwb_group_hrchy hrchy
876: ,ben_cwb_person_groups grp
877: ,ben_cwb_person_info info
878: where info.group_pl_id = p_group_pl_id
879: and info.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
880: and info.group_per_in_ler_id = hrchy.emp_per_in_ler_id

Line 930: ,ben_cwb_person_groups grp

926: grp.dist_bdgt_iss_val)* decode(nvl(grp.dist_bdgt_val,0),0,
927: summ.elig_sal_val_direct,summ.elig_sal_val_all) /100)
928: bdgt_iss_val_direct
929: from ben_cwb_group_hrchy hrchy
930: ,ben_cwb_person_groups grp
931: ,ben_cwb_summary summ
932: ,ben_cwb_person_info info
933: where info.group_pl_id = p_group_pl_id
934: and info.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 1423: ,ben_cwb_person_groups grp

1419: ,grp.group_oipl_id
1420: ,pil.person_id
1421: ,p_lf_evt_ocrd_dt
1422: from ben_cwb_group_hrchy hrchy
1423: ,ben_cwb_person_groups grp
1424: ,ben_per_in_ler pil
1425: where hrchy.lvl_num=0
1426: and hrchy.emp_per_in_ler_id = grp.group_per_in_ler_id
1427: and pil.group_pl_id = p_group_pl_id

Line 1553: ,ben_cwb_person_groups grp

1549: grp.dist_bdgt_iss_val) * decode(nvl(grp.dist_bdgt_val,0),0,
1550: summ.elig_sal_val_direct, summ.elig_sal_val_all) / 100)
1551: bdgt_iss_val_direct
1552: from ben_cwb_group_hrchy hrchy
1553: ,ben_cwb_person_groups grp
1554: ,ben_cwb_summary summ
1555: where hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id
1556: and hrchy.lvl_num = 1
1557: and grp.group_per_in_ler_id = hrchy.emp_per_in_ler_id

Line 1575: ,ben_cwb_person_groups grp

1571: grp.dist_bdgt_val)) bdgt_val_direct
1572: ,sum(decode(nvl(grp.dist_bdgt_val,0),0,grp.ws_bdgt_iss_val,
1573: grp.dist_bdgt_iss_val)) bdgt_iss_val_direct
1574: from ben_cwb_group_hrchy hrchy
1575: ,ben_cwb_person_groups grp
1576: where hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id
1577: and hrchy.lvl_num = 1
1578: and grp.group_per_in_ler_id = hrchy.emp_per_in_ler_id
1579: group by grp.group_pl_id, grp.group_oipl_id

Line 1591: ,ben_cwb_person_groups grp

1587: ws_bdgt_val_all
1588: ,sum(grp.ws_bdgt_iss_val * summ.elig_sal_val_direct / 100)
1589: ws_bdgt_iss_val_all
1590: from ben_cwb_group_hrchy hrchy
1591: ,ben_cwb_person_groups grp
1592: ,ben_cwb_summary summ
1593: where hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id
1594: and hrchy.lvl_num >= 1
1595: and grp.group_per_in_ler_id = hrchy.emp_per_in_ler_id

Line 1609: ,ben_cwb_person_groups grp

1605: ,grp.group_oipl_id group_oipl_id
1606: ,sum(grp.ws_bdgt_val) ws_bdgt_val_all
1607: ,sum(grp.ws_bdgt_iss_val) ws_bdgt_iss_val_all
1608: from ben_cwb_group_hrchy hrchy
1609: ,ben_cwb_person_groups grp
1610: where hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id
1611: and hrchy.lvl_num >= 1
1612: and grp.group_per_in_ler_id = hrchy.emp_per_in_ler_id
1613: group by grp.group_pl_id, grp.group_oipl_id

Line 1849: ,ben_cwb_person_groups grp

1845: ,grp.group_oipl_id
1846: ,pil.person_id
1847: from ben_cwb_group_hrchy hrchy
1848: ,ben_cwb_person_info per
1849: ,ben_cwb_person_groups grp
1850: ,ben_per_in_ler pil
1851: where per.person_id = -1
1852: and per.group_per_in_ler_id = hrchy.emp_per_in_ler_id
1853: and hrchy.mgr_per_in_ler_id = grp.group_per_in_ler_id

Line 2475: ,ben_cwb_person_groups grp

2471: select sum(sm.elig_count_all)-sum(sm.elig_count_direct) indirect_count
2472: ,sum(sm.elig_count_all) all_count
2473: ,max(grp.bdgt_pop_cd) bdgt_pop_cd
2474: from ben_cwb_summary sm
2475: ,ben_cwb_person_groups grp
2476: where sm.group_per_in_ler_id = l_per_in_ler_id
2477: and sm.group_oipl_id = -1
2478: and sm.group_per_in_ler_id = grp.group_per_in_ler_id
2479: and sm.group_pl_id = grp.group_pl_id

Line 2493: from ben_cwb_person_groups grp

2489: ,grp.dist_bdgt_iss_val
2490: ,grp.ws_bdgt_val
2491: ,grp.ws_bdgt_iss_val
2492: ,grp.ws_bdgt_iss_date
2493: from ben_cwb_person_groups grp
2494: where grp.group_per_in_ler_id = l_per_in_ler_id;
2495: --
2496: cursor c_mgr_pop_cd is
2497: select grp.bdgt_pop_cd

Line 2499: ,ben_cwb_person_groups grp

2495: --
2496: cursor c_mgr_pop_cd is
2497: select grp.bdgt_pop_cd
2498: from ben_cwb_group_hrchy hrchy
2499: ,ben_cwb_person_groups grp
2500: where hrchy.emp_per_in_ler_id = l_per_in_ler_id
2501: and hrchy.mgr_per_in_ler_id = grp.group_per_in_ler_id
2502: and hrchy.lvl_num = 1
2503: and grp.group_oipl_id = -1;

Line 2554: ben_cwb_person_groups_api.update_group_budget(

2550:
2551: if l_summary.all_count < 1 then
2552: -- No longer a manager.
2553: -- Remove the worksheet and dist bdgt.
2554: ben_cwb_person_groups_api.update_group_budget(
2555: p_group_per_in_ler_id => l_per_in_ler_id
2556: ,p_group_pl_id => l_grps.group_pl_id
2557: ,p_group_oipl_id => l_grps.group_oipl_id
2558: ,p_lf_evt_ocrd_dt => l_grps.lf_evt_ocrd_dt

Line 2578: ben_cwb_person_groups_api.update_group_budget(

2574: if g_debug then
2575: hr_utility.set_location(l_proc, 40);
2576: end if;
2577: --
2578: ben_cwb_person_groups_api.update_group_budget(
2579: p_group_per_in_ler_id => l_per_in_ler_id
2580: ,p_group_pl_id => l_grps.group_pl_id
2581: ,p_group_oipl_id => l_grps.group_oipl_id
2582: ,p_lf_evt_ocrd_dt => l_grps.lf_evt_ocrd_dt

Line 2608: ben_cwb_person_groups_api.update_group_budget(

2604: close c_mgr_pop_cd;
2605:
2606: if l_mgr_pop_cd = 'D' then
2607: -- Copy the worksheet budget to distribution budget.
2608: ben_cwb_person_groups_api.update_group_budget(
2609: p_group_per_in_ler_id => l_per_in_ler_id
2610: ,p_group_pl_id => l_grps.group_pl_id
2611: ,p_group_oipl_id => l_grps.group_oipl_id
2612: ,p_lf_evt_ocrd_dt => l_grps.lf_evt_ocrd_dt

Line 3017: ,ben_cwb_person_groups grp

3013: ,pl.uses_bdgt_flag
3014: into l_prsrv_bdgt_cd
3015: ,l_uses_bdgt_flag
3016: from ben_cwb_pl_dsgn pl
3017: ,ben_cwb_person_groups grp
3018: where grp.group_per_in_ler_id = nvl(p_new_mgr_per_in_ler_id,p_old_mgr_per_in_ler_id)
3019: and grp.group_oipl_id = -1
3020: and pl.pl_id = grp.group_pl_id
3021: and pl.oipl_id = grp.group_oipl_id

Line 3397: ,ben_cwb_person_groups grp

3393: ,pl.uses_bdgt_flag
3394: into l_prsrv_bdgt_cd
3395: ,l_uses_bdgt_flag
3396: from ben_cwb_pl_dsgn pl
3397: ,ben_cwb_person_groups grp
3398: where grp.group_per_in_ler_id = nvl(p_new_mgr_per_in_ler_id, p_old_mgr_per_in_ler_id)
3399: and grp.group_oipl_id = -1
3400: and pl.pl_id = grp.group_pl_id
3401: and pl.oipl_id = grp.group_oipl_id

Line 3617: from ben_cwb_person_groups grp

3613: ,grp.group_pl_id
3614: ,grp.group_oipl_id
3615: ,pil.person_id
3616: ,pil.lf_evt_ocrd_dt
3617: from ben_cwb_person_groups grp
3618: ,ben_per_in_ler pil
3619: where grp.group_per_in_ler_id = p_new_mgr_per_in_ler_id
3620: and grp.group_per_in_ler_id = pil.per_in_ler_id
3621: and pil.per_in_ler_stat_cd in ('PROCD','STRTD')

Line 3697: ,ben_cwb_person_groups grp

3693: ,grp.group_oipl_id
3694: ,grp.ws_bdgt_val * p_sal / 100 ws_bdgt_val
3695: ,grp.ws_bdgt_iss_val * p_sal / 100 ws_bdgt_iss_val
3696: from ben_cwb_group_hrchy hrchy
3697: ,ben_cwb_person_groups grp
3698: where hrchy.emp_per_in_ler_id = p_group_per_in_ler_id
3699: and hrchy.mgr_per_in_ler_id = grp.group_per_in_ler_id
3700: and hrchy.lvl_num = 1
3701: order by grp.group_pl_id, grp.group_oipl_id;

Line 3718: ben_cwb_person_groups.group_per_in_ler_id%type;

3714:
3715:
3716: -- Type delcarations for pl/sql tables
3717: type group_per_in_ler_id_type is table of
3718: ben_cwb_person_groups.group_per_in_ler_id%type;
3719: type group_pl_id_type is table of
3720: ben_cwb_person_groups.group_pl_id%type;
3721: type group_oipl_id_type is table of
3722: ben_cwb_person_groups.group_oipl_id%type;

Line 3720: ben_cwb_person_groups.group_pl_id%type;

3716: -- Type delcarations for pl/sql tables
3717: type group_per_in_ler_id_type is table of
3718: ben_cwb_person_groups.group_per_in_ler_id%type;
3719: type group_pl_id_type is table of
3720: ben_cwb_person_groups.group_pl_id%type;
3721: type group_oipl_id_type is table of
3722: ben_cwb_person_groups.group_oipl_id%type;
3723: type ws_bdgt_val_type is table of
3724: ben_cwb_person_groups.ws_bdgt_val%type;

Line 3722: ben_cwb_person_groups.group_oipl_id%type;

3718: ben_cwb_person_groups.group_per_in_ler_id%type;
3719: type group_pl_id_type is table of
3720: ben_cwb_person_groups.group_pl_id%type;
3721: type group_oipl_id_type is table of
3722: ben_cwb_person_groups.group_oipl_id%type;
3723: type ws_bdgt_val_type is table of
3724: ben_cwb_person_groups.ws_bdgt_val%type;
3725: type ws_bdgt_iss_val_type is table of
3726: ben_cwb_person_groups.ws_bdgt_iss_val%type;

Line 3724: ben_cwb_person_groups.ws_bdgt_val%type;

3720: ben_cwb_person_groups.group_pl_id%type;
3721: type group_oipl_id_type is table of
3722: ben_cwb_person_groups.group_oipl_id%type;
3723: type ws_bdgt_val_type is table of
3724: ben_cwb_person_groups.ws_bdgt_val%type;
3725: type ws_bdgt_iss_val_type is table of
3726: ben_cwb_person_groups.ws_bdgt_iss_val%type;
3727:
3728: -- declare pl/sql tables

Line 3726: ben_cwb_person_groups.ws_bdgt_iss_val%type;

3722: ben_cwb_person_groups.group_oipl_id%type;
3723: type ws_bdgt_val_type is table of
3724: ben_cwb_person_groups.ws_bdgt_val%type;
3725: type ws_bdgt_iss_val_type is table of
3726: ben_cwb_person_groups.ws_bdgt_iss_val%type;
3727:
3728: -- declare pl/sql tables
3729: l_group_pl_id_tab group_pl_id_type;
3730: l_group_oipl_id_tab group_oipl_id_type;

Line 3754: ,ben_cwb_person_groups grp

3750: ,pl.uses_bdgt_flag
3751: into l_prsrv_bdgt_cd
3752: ,l_uses_bdgt_flag
3753: from ben_cwb_pl_dsgn pl
3754: ,ben_cwb_person_groups grp
3755: where grp.group_per_in_ler_id = p_group_per_in_ler_id
3756: and grp.group_oipl_id = -1
3757: and pl.pl_id = grp.group_pl_id
3758: and pl.oipl_id = grp.group_oipl_id

Line 3807: from ben_cwb_person_groups grp

3803: ,decode(nvl(grp.dist_bdgt_iss_val,0),0,grp.ws_bdgt_iss_val,
3804: grp.dist_bdgt_iss_val) * p_elig_sal_change /100
3805: into l_bdgt_val
3806: ,l_bdgt_iss_val
3807: from ben_cwb_person_groups grp
3808: where grp.group_per_in_ler_id = mgr.per_in_ler_id
3809: and grp.group_pl_id = l_group_pl_id_tab(i)
3810: and grp.group_oipl_id = l_group_oipl_id_tab(i);
3811: --