APPS.BEN_CWB_SUMMARY_PKG dependencies on BEN_CWB_PL_DSGN

Line 44: ,ben_cwb_pl_dsgn pl

40: ,xchg.xchg_rate,1) misc2_val
41: ,rt.misc3_val/decode(pl.misc3_nnmntry_uom,null
42: ,xchg.xchg_rate,1) misc3_val
43: from ben_cwb_person_rates rt
44: ,ben_cwb_pl_dsgn pl
45: ,ben_cwb_xchg xchg
46: where rt.group_per_in_ler_id = v_per_in_ler_id
47: and rt.pl_id = pl.pl_id
48: and rt.oipl_id = pl.oipl_id

Line 1030: from ben_cwb_pl_dsgn

1026: --
1027: -- get the prsrv_bdgt_cd from pl_dsgn
1028: select prsrv_bdgt_cd, uses_bdgt_flag
1029: into l_prsrv_bdgt_cd, l_uses_bdgt_flag
1030: from ben_cwb_pl_dsgn
1031: where pl_id = p_group_pl_id
1032: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
1033: and oipl_id = -1;
1034: --

Line 1314: ,ben_cwb_pl_dsgn pl

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
1317: and rt.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
1318: and rt.elig_flag = 'Y'

Line 1895: ,ben_cwb_pl_dsgn pl

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
1898: and rt.group_per_in_ler_id = hrchy.emp_per_in_ler_id
1899: and hrchy.lvl_num = 1

Line 2154: from ben_cwb_pl_dsgn

2150: end loop; --emps
2151: --
2152: select prsrv_bdgt_cd, uses_bdgt_flag
2153: into l_prsrv_bdgt_cd, l_uses_bdgt_flag
2154: from ben_cwb_pl_dsgn
2155: where pl_id = p_group_pl_id
2156: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
2157: and oipl_id = -1;
2158: --

Line 3016: from ben_cwb_pl_dsgn pl

3012: select pl.prsrv_bdgt_cd
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

Line 3396: from ben_cwb_pl_dsgn pl

3392: select pl.prsrv_bdgt_cd
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

Line 3753: from ben_cwb_pl_dsgn pl

3749: select pl.prsrv_bdgt_cd
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