APPS.BENUTILS dependencies on BEN_ACTY_BASE_RT_F

Line 5509: p_business_group_id IN ben_acty_base_rt_f.business_group_id%TYPE,

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

Line 5510: p_acty_base_rt_id IN ben_acty_base_rt_f.acty_base_rt_id%TYPE,

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)
5513: Return Varchar2
5514: Is

Line 5518: lv_abr_name ben_acty_base_rt_f.name%TYPE;

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);
5520:
5521: Begin
5522: Begin

Line 5538: From ben_acty_base_rt_f abr,

5534: (Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5535: abr.business_group_id business_group_id,
5536: pl.name pl_name, Null opt_name, abr.name abr_name,
5537: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5538: From ben_acty_base_rt_f abr,
5539: ben_plip_f plip,
5540: ben_pl_f pl,
5541: fnd_sessions se
5542: Where se.session_id = p_session_id

Line 5561: From ben_acty_base_rt_f abr,

5557: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5558: abr.business_group_id,
5559: pl.name pl_name, Null opt_name, abr.name abr_name,
5560: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5561: From ben_acty_base_rt_f abr,
5562: ben_plip_f plip,
5563: ben_pl_f pl,
5564: fnd_sessions se
5565: Where se.session_id = p_session_id

Line 5584: From ben_acty_base_rt_f abr,

5580: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5581: abr.business_group_id,
5582: pl.name pl_name, opt.name opt_name, abr.name abr_name,
5583: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5584: From ben_acty_base_rt_f abr,
5585: ben_plip_f plip,
5586: ben_pl_f pl,
5587: ben_oipl_f oipl,
5588: ben_opt_f opt,

Line 5613: From ben_acty_base_rt_f abr,

5609: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5610: abr.business_group_id,
5611: pl.name pl_name, opt.name opt_name, abr.name abr_name,
5612: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5613: From ben_acty_base_rt_f abr,
5614: ben_plip_f plip,
5615: ben_pl_f pl,
5616: ben_oipl_f oipl,
5617: ben_oiplip_f oiplip,