APPS.BEN_CWB_PERSON_GROUPS_API dependencies on BEN_CWB_SUMMARY

Line 505: from ben_cwb_summary

501: select sum(elig_sal_val_direct) elig_sal_val_direct
502: ,sum(elig_sal_val_all) elig_sal_val_all
503: into l_elig_sal_direct
504: ,l_elig_sal_all
505: from ben_cwb_summary
506: where group_per_in_ler_id = p_grp_bdgt_old.group_per_in_ler_id
507: and group_pl_id = p_grp_bdgt_old.group_pl_id
508: and group_oipl_id = p_grp_bdgt_old.group_oipl_id;
509: --

Line 546: ben_cwb_summary_pkg.update_or_insert_pl_sql_tab

542: if g_debug then
543: hr_utility.set_location(l_proc, 70);
544: end if;
545: --
546: ben_cwb_summary_pkg.update_or_insert_pl_sql_tab
547: (p_group_per_in_ler_id => mgr.mgr_per_in_ler_id
548: ,p_group_pl_id => p_grp_bdgt_old.group_pl_id
549: ,p_group_oipl_id => p_grp_bdgt_old.group_oipl_id
550: ,p_ws_bdgt_val_direct => l_diff_ws_bdgt * l_immediate_mgr