APPS.BENUTILS dependencies on BEN_ACTY_BASE_RT_F

Line 5384: p_business_group_id IN ben_acty_base_rt_f.business_group_id%TYPE,

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)
5388: Return Varchar2

Line 5385: p_acty_base_rt_id IN ben_acty_base_rt_f.acty_base_rt_id%TYPE,

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)
5388: Return Varchar2
5389: Is

Line 5393: lv_abr_name ben_acty_base_rt_f.name%TYPE;

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);
5395:
5396: Begin
5397: Begin

Line 5413: From ben_acty_base_rt_f abr,

5409: (Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5410: abr.business_group_id business_group_id,
5411: pl.name pl_name, Null opt_name, abr.name abr_name,
5412: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5413: From ben_acty_base_rt_f abr,
5414: ben_plip_f plip,
5415: ben_pl_f pl,
5416: fnd_sessions se
5417: Where se.session_id = p_session_id

Line 5436: From ben_acty_base_rt_f abr,

5432: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5433: abr.business_group_id,
5434: pl.name pl_name, Null opt_name, abr.name abr_name,
5435: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5436: From ben_acty_base_rt_f abr,
5437: ben_plip_f plip,
5438: ben_pl_f pl,
5439: fnd_sessions se
5440: Where se.session_id = p_session_id

Line 5459: From ben_acty_base_rt_f abr,

5455: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5456: abr.business_group_id,
5457: pl.name pl_name, opt.name opt_name, abr.name abr_name,
5458: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5459: From ben_acty_base_rt_f abr,
5460: ben_plip_f plip,
5461: ben_pl_f pl,
5462: ben_oipl_f oipl,
5463: ben_opt_f opt,

Line 5488: From ben_acty_base_rt_f abr,

5484: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5485: abr.business_group_id,
5486: pl.name pl_name, opt.name opt_name, abr.name abr_name,
5487: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5488: From ben_acty_base_rt_f abr,
5489: ben_plip_f plip,
5490: ben_pl_f pl,
5491: ben_oipl_f oipl,
5492: ben_oiplip_f oiplip,