APPS.BENUTILS dependencies on BEN_BNFT_PRVDR_POOL_F

Line 5383: (p_bnft_prvdr_pool_id IN ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE,

5379: -- Bug 2016857
5380: --
5381: -- Bug 2428672
5382: Function ben_get_abp_plan_opt_names
5383: (p_bnft_prvdr_pool_id IN ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE,
5384: p_business_group_id IN ben_acty_base_rt_f.business_group_id%TYPE,
5385: p_acty_base_rt_id IN ben_acty_base_rt_f.acty_base_rt_id%TYPE,
5386: p_session_id IN fnd_sessions.session_id%TYPE,
5387: ret_flag IN varchar2)

Line 5390: lv_pgm_id ben_bnft_prvdr_pool_f.pgm_id%TYPE;

5386: p_session_id IN fnd_sessions.session_id%TYPE,
5387: ret_flag IN varchar2)
5388: Return Varchar2
5389: Is
5390: lv_pgm_id ben_bnft_prvdr_pool_f.pgm_id%TYPE;
5391: lv_pl_name ben_pl_f.name%TYPE;
5392: lv_opt_name ben_opt_f.name%TYPE;
5393: lv_abr_name ben_acty_base_rt_f.name%TYPE;
5394: lv_meaning Varchar2(60);

Line 5400: From ben_bnft_prvdr_pool_f bpp,

5396: Begin
5397: Begin
5398: Select bpp.pgm_id
5399: Into lv_pgm_id
5400: From ben_bnft_prvdr_pool_f bpp,
5401: fnd_sessions se
5402: Where se.session_id = p_session_id
5403: And bpp.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
5404: And se.effective_date Between bpp.effective_start_date And bpp.effective_End_date;