APPS.BENUTILS dependencies on FND_SESSIONS

Line 5386: p_session_id IN fnd_sessions.session_id%TYPE,

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

Line 5401: fnd_sessions se

5397: Begin
5398: Select bpp.pgm_id
5399: Into lv_pgm_id
5400: From ben_bnft_prvdr_pool_f bpp,
5401: fnd_sessions se
5402: Where se.session_id = p_session_id
5403: And bpp.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
5404: And se.effective_date Between bpp.effective_start_date And bpp.effective_End_date;
5405:

Line 5416: fnd_sessions se

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
5418: And plip.pgm_id = lv_pgm_id
5419: And plip.pl_id = pl.pl_id
5420: And abr.pl_id = pl.pl_id

Line 5439: fnd_sessions se

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
5441: And plip.pgm_id = lv_pgm_id
5442: And plip.pl_id = pl.pl_id
5443: And abr.plip_id = plip.plip_id

Line 5464: fnd_sessions se

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

Line 5494: fnd_sessions se

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

Line 5689: from fnd_sessions se

5685: return date is
5686: --
5687: cursor c_session_date is
5688: select se.effective_date
5689: from fnd_sessions se
5690: where session_id = userenv('SESSIONID');
5691: --
5692: l_session_date date := p_session_date;
5693: --