APPS.BENUTILS dependencies on FND_SESSIONS

Line 5511: p_session_id IN fnd_sessions.session_id%TYPE,

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
5515: lv_pgm_id ben_bnft_prvdr_pool_f.pgm_id%TYPE;

Line 5526: fnd_sessions se

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;
5530:

Line 5541: fnd_sessions se

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
5543: And plip.pgm_id = lv_pgm_id
5544: And plip.pl_id = pl.pl_id
5545: And abr.pl_id = pl.pl_id

Line 5564: fnd_sessions se

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
5566: And plip.pgm_id = lv_pgm_id
5567: And plip.pl_id = pl.pl_id
5568: And abr.plip_id = plip.plip_id

Line 5589: fnd_sessions se

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
5593: And oipl.pl_id = pl.pl_id

Line 5619: fnd_sessions se

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
5623: And oipl.pl_id = pl.pl_id

Line 5814: from fnd_sessions se

5810: return date is
5811: --
5812: cursor c_session_date is
5813: select se.effective_date
5814: from fnd_sessions se
5815: where session_id = userenv('SESSIONID');
5816: --
5817: l_session_date date := p_session_date;
5818: --