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_GROUP_HRCHY

Line 86: from ben_cwb_group_hrchy hrchy1

82: cursor csr_mgr_ids(v_mgr_per_in_ler_id1 number
83: ,v_mgr_per_in_ler_id2 number) is
84: select mgr_per_in_ler_id
85: ,lvl_num
86: from ben_cwb_group_hrchy hrchy1
87: where emp_per_in_ler_id = v_mgr_per_in_ler_id1
88: and mgr_per_in_ler_id not in
89: (select mgr_per_in_ler_id
90: from ben_cwb_group_hrchy hrchy2

Line 90: from ben_cwb_group_hrchy hrchy2

86: from ben_cwb_group_hrchy hrchy1
87: where emp_per_in_ler_id = v_mgr_per_in_ler_id1
88: and mgr_per_in_ler_id not in
89: (select mgr_per_in_ler_id
90: from ben_cwb_group_hrchy hrchy2
91: where emp_per_in_ler_id = v_mgr_per_in_ler_id2
92: and mgr_per_in_ler_id <> v_mgr_per_in_ler_id1
93: and lvl_num > 0)
94: order by lvl_num;

Line 99: from ben_cwb_group_hrchy

95: --
96: cursor csr_mgrs(v_per_in_ler_id in number) is
97: select mgr_per_in_ler_id
98: ,lvl_num
99: from ben_cwb_group_hrchy
100: where emp_per_in_ler_id = v_per_in_ler_id
101: and lvl_num > 0
102: order by lvl_num;
103:

Line 849: from ben_cwb_group_hrchy hrchy

845: sum(grp.ws_bdgt_val * summ.elig_sal_val_direct/100)
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

Line 875: from ben_cwb_group_hrchy hrchy

871: ,sum(decode(nvl(grp.dist_bdgt_val,0),0,grp.ws_bdgt_val,
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

Line 905: from ben_cwb_group_hrchy hrchy

901: ,sum(rec_mx_val_direct) rec_mx_val_all
902: ,sum(misc1_val_direct) misc1_val_all
903: ,sum(misc2_val_direct) misc2_val_all
904: ,sum(misc3_val_direct) misc3_val_all
905: from ben_cwb_group_hrchy hrchy
906: ,ben_cwb_summary summ
907: ,ben_cwb_person_info info
908: where info.group_pl_id = p_group_pl_id
909: and info.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 929: from ben_cwb_group_hrchy hrchy

925: ,sum(decode(nvl(grp.dist_bdgt_val,0),0, grp.ws_bdgt_iss_val,
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

Line 1312: from ben_cwb_group_hrchy hrchy

1308: ,sum(rt.misc2_val/decode(pl.misc2_nnmntry_uom,null
1309: ,xchg.xchg_rate,1)) misc2_val_direct
1310: ,sum(rt.misc3_val/decode(pl.misc3_nnmntry_uom,null
1311: ,xchg.xchg_rate,1)) misc3_val_direct
1312: from ben_cwb_group_hrchy hrchy
1313: ,ben_cwb_person_rates rt
1314: ,ben_cwb_pl_dsgn pl
1315: ,ben_cwb_xchg xchg
1316: where rt.group_pl_id = p_group_pl_id

Line 1422: from ben_cwb_group_hrchy hrchy

1418: ,p_group_pl_id
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

Line 1552: from ben_cwb_group_hrchy hrchy

1548: ,sum(decode(nvl(grp.dist_bdgt_val,0),0,grp.ws_bdgt_iss_val,
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

Line 1574: from ben_cwb_group_hrchy hrchy

1570: ,sum(decode(nvl(grp.dist_bdgt_val,0),0,grp.ws_bdgt_val,
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

Line 1590: from ben_cwb_group_hrchy hrchy

1586: ,sum(grp.ws_bdgt_val * summ.elig_sal_val_direct / 100)
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

Line 1608: from ben_cwb_group_hrchy hrchy

1604: select grp.group_pl_id group_pl_id
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

Line 1833: ,ben_cwb_group_hrchy hrchy

1829: cursor csr_emps is
1830: select per.group_per_in_ler_id
1831: ,hrchy.mgr_per_in_ler_id
1832: from ben_cwb_person_info per
1833: ,ben_cwb_group_hrchy hrchy
1834: where per.person_id = -1
1835: and per.group_pl_id = p_group_pl_id
1836: and per.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
1837: and per.group_per_in_ler_id = hrchy.emp_per_in_ler_id (+)

Line 1847: from ben_cwb_group_hrchy hrchy

1843: select hrchy.mgr_per_in_ler_id
1844: ,p_group_pl_id group_pl_id
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

Line 1893: from ben_cwb_group_hrchy hrchy

1889: ,sum(rt.misc2_val/decode(pl.misc2_nnmntry_uom,null
1890: ,xchg.xchg_rate,1)) misc2_val
1891: ,sum(rt.misc3_val/decode(pl.misc3_nnmntry_uom,null
1892: ,xchg.xchg_rate,1)) misc3_val
1893: from ben_cwb_group_hrchy hrchy
1894: ,ben_cwb_person_rates rt
1895: ,ben_cwb_pl_dsgn pl
1896: ,ben_cwb_xchg xchg
1897: where hrchy.mgr_per_in_ler_id = v_group_per_in_ler_id

Line 1927: from ben_cwb_group_hrchy hrchy

1923: ,sum(rec_mx_val_direct) rec_mx_val
1924: ,sum(misc1_val_direct) misc1_val
1925: ,sum(misc2_val_direct) misc2_val
1926: ,sum(misc3_val_direct) misc3_val
1927: from ben_cwb_group_hrchy hrchy
1928: ,ben_cwb_summary summ
1929: where hrchy.mgr_per_in_ler_id = v_group_per_in_ler_id
1930: and hrchy.lvl_num >=0
1931: and hrchy.emp_per_in_ler_id = summ.group_per_in_ler_id

Line 1938: from ben_cwb_group_hrchy h

1934: cursor csr_mgrs_info(v_per_in_ler_id in number) is
1935: select h.mgr_per_in_ler_id
1936: ,h.lvl_num
1937: ,i.person_id
1938: from ben_cwb_group_hrchy h
1939: ,ben_cwb_person_info i
1940: where h.emp_per_in_ler_id = v_per_in_ler_id
1941: and h.lvl_num > 0
1942: and h.mgr_per_in_ler_id = i.group_per_in_ler_id

Line 2466: from ben_cwb_group_hrchy hrchy

2462: l_per_in_ler_id number := null;
2463: --
2464: cursor c_mgr_id is
2465: select hrchy.mgr_per_in_ler_id
2466: from ben_cwb_group_hrchy hrchy
2467: where hrchy.emp_per_in_ler_id = p_per_in_ler_id
2468: and hrchy.lvl_num = p_lvl_up;
2469: --
2470: cursor c_summary is

Line 2498: from ben_cwb_group_hrchy hrchy

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
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

Line 3552: from ben_cwb_group_hrchy

3548: --
3549: --check if the emp was a manager earlier
3550: begin
3551: select null into l_dummy
3552: from ben_cwb_group_hrchy
3553: where mgr_per_in_ler_id = p_emp_per_in_ler_id
3554: and lvl_num = 0;
3555: --
3556: l_is_mgr := 'Y';

Line 3574: from ben_cwb_group_hrchy hrchy

3570: -- of one hierarchy to another person) dont insert the rec.
3571: if (p_old_mgr_per_in_ler_id is not null) then
3572: begin
3573: select null into l_dummy
3574: from ben_cwb_group_hrchy hrchy
3575: where emp_per_in_ler_id = p_old_mgr_per_in_ler_id
3576: and lvl_num = 0;
3577: --
3578: if g_debug then

Line 3585: insert into ben_cwb_group_hrchy(mgr_per_in_ler_id

3581: --
3582: exception
3583: when no_data_found then
3584: -- row is not present;
3585: insert into ben_cwb_group_hrchy(mgr_per_in_ler_id
3586: ,emp_per_in_ler_id
3587: ,lvl_num)
3588: values(p_old_mgr_per_in_ler_id
3589: ,p_old_mgr_per_in_ler_id

Line 3648: delete from ben_cwb_group_hrchy

3644: if g_debug then
3645: hr_utility.set_location(l_proc, 50);
3646: end if;
3647: --
3648: delete from ben_cwb_group_hrchy
3649: where mgr_per_in_ler_id = p_old_mgr_per_in_ler_id
3650: and lvl_num = 0;
3651: end if;
3652:

Line 3696: from ben_cwb_group_hrchy hrchy

3692: select grp.group_pl_id
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

Line 3707: from ben_cwb_group_hrchy hrchy

3703: -- get the mgr ids of the person.
3704: cursor mgr_ids(p_group_per_in_ler_id number) is
3705: select hrchy.mgr_per_in_ler_id per_in_ler_id
3706: ,mgr.mgr_per_in_ler_id next_mgr_id
3707: from ben_cwb_group_hrchy hrchy
3708: ,ben_cwb_group_hrchy mgr
3709: where hrchy.emp_per_in_ler_id = p_group_per_in_ler_id
3710: and hrchy.lvl_num > 0
3711: and mgr.emp_per_in_ler_id (+) = hrchy.mgr_per_in_ler_id

Line 3708: ,ben_cwb_group_hrchy mgr

3704: cursor mgr_ids(p_group_per_in_ler_id number) is
3705: select hrchy.mgr_per_in_ler_id per_in_ler_id
3706: ,mgr.mgr_per_in_ler_id next_mgr_id
3707: from ben_cwb_group_hrchy hrchy
3708: ,ben_cwb_group_hrchy mgr
3709: where hrchy.emp_per_in_ler_id = p_group_per_in_ler_id
3710: and hrchy.lvl_num > 0
3711: and mgr.emp_per_in_ler_id (+) = hrchy.mgr_per_in_ler_id
3712: and mgr.lvl_num (+) = 1