DBA Data[Home] [Help]

APPS.BENUTILS dependencies on BEN_OPT_F

Line 5517: lv_opt_name ben_opt_f.name%TYPE;

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

Line 5588: ben_opt_f opt,

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,
5589: fnd_sessions se
5590: Where se.session_id = p_session_id
5591: And plip.pgm_id = lv_pgm_id
5592: And plip.pl_id = pl.pl_id

Line 5618: ben_opt_f opt,

5614: ben_plip_f plip,
5615: ben_pl_f pl,
5616: ben_oipl_f oipl,
5617: ben_oiplip_f oiplip,
5618: ben_opt_f opt,
5619: fnd_sessions se
5620: Where se.session_id = p_session_id
5621: And plip.pgm_id = lv_pgm_id
5622: And plip.pl_id = pl.pl_id