APPS.BENUTILS dependencies on BEN_BNFT_PRVDR_POOL_F

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

5504: -- Bug 2016857
5505: --
5506: -- Bug 2428672
5507: Function ben_get_abp_plan_opt_names
5508: (p_bnft_prvdr_pool_id IN ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE,
5509: p_business_group_id IN ben_acty_base_rt_f.business_group_id%TYPE,
5510: p_acty_base_rt_id IN ben_acty_base_rt_f.acty_base_rt_id%TYPE,
5511: p_session_id IN fnd_sessions.session_id%TYPE,
5512: ret_flag IN varchar2)

Line 5515: lv_pgm_id ben_bnft_prvdr_pool_f.pgm_id%TYPE;

5511: p_session_id IN fnd_sessions.session_id%TYPE,
5512: ret_flag IN varchar2)
5513: Return Varchar2
5514: Is
5515: lv_pgm_id ben_bnft_prvdr_pool_f.pgm_id%TYPE;
5516: lv_pl_name ben_pl_f.name%TYPE;
5517: lv_opt_name ben_opt_f.name%TYPE;
5518: lv_abr_name ben_acty_base_rt_f.name%TYPE;
5519: lv_meaning Varchar2(60);

Line 5525: From ben_bnft_prvdr_pool_f bpp,

5521: Begin
5522: Begin
5523: Select bpp.pgm_id
5524: Into lv_pgm_id
5525: From ben_bnft_prvdr_pool_f bpp,
5526: fnd_sessions se
5527: Where se.session_id = p_session_id
5528: And bpp.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
5529: And se.effective_date Between bpp.effective_start_date And bpp.effective_End_date;