APPS.BENUTILS dependencies on BEN_OPT_F

Line 5392: lv_opt_name ben_opt_f.name%TYPE;

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

Line 5463: ben_opt_f opt,

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,
5464: fnd_sessions se
5465: Where se.session_id = p_session_id
5466: And plip.pgm_id = lv_pgm_id
5467: And plip.pl_id = pl.pl_id

Line 5493: ben_opt_f opt,

5489: ben_plip_f plip,
5490: ben_pl_f pl,
5491: ben_oipl_f oipl,
5492: ben_oiplip_f oiplip,
5493: ben_opt_f opt,
5494: fnd_sessions se
5495: Where se.session_id = p_session_id
5496: And plip.pgm_id = lv_pgm_id
5497: And plip.pl_id = pl.pl_id