APPS.BENUTILS dependencies on BEN_PL_F

Line 5124: from ben_pl_f pl

5120: --
5121: CURSOR c_ref_perd_cd IS
5122: select pl.nip_acty_ref_perd_cd
5123: ,nvl(cur.precision,2)
5124: from ben_pl_f pl
5125: ,fnd_currencies cur
5126: where pl.pl_id = p_pl_id
5127: and p_effective_date between pl.effective_start_date
5128: and pl.effective_end_date

Line 5210: from ben_pl_f pl

5206: --
5207: CURSOR c_ref_perd_cd IS
5208: select pl.nip_acty_ref_perd_cd
5209: ,nvl(cur.precision,2)
5210: from ben_pl_f pl
5211: ,fnd_currencies cur
5212: where pl.pl_id = p_pl_id
5213: and p_effective_date between pl.effective_start_date
5214: and pl.effective_end_date

Line 5391: lv_pl_name ben_pl_f.name%TYPE;

5387: ret_flag IN varchar2)
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:

Line 5415: ben_pl_f pl,

5411: pl.name pl_name, Null opt_name, abr.name abr_name,
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

Line 5438: ben_pl_f pl,

5434: pl.name pl_name, Null opt_name, abr.name abr_name,
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

Line 5461: ben_pl_f pl,

5457: pl.name pl_name, opt.name opt_name, abr.name abr_name,
5458: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
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

Line 5490: ben_pl_f pl,

5486: pl.name pl_name, opt.name opt_name, abr.name abr_name,
5487: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5488: From ben_acty_base_rt_f abr,
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