APPS.BENUTILS dependencies on BEN_PL_F

Line 5249: from ben_pl_f pl

5245: --
5246: CURSOR c_ref_perd_cd IS
5247: select pl.nip_acty_ref_perd_cd
5248: ,nvl(cur.precision,2)
5249: from ben_pl_f pl
5250: ,fnd_currencies cur
5251: where pl.pl_id = p_pl_id
5252: and p_effective_date between pl.effective_start_date
5253: and pl.effective_end_date

Line 5335: from ben_pl_f pl

5331: --
5332: CURSOR c_ref_perd_cd IS
5333: select pl.nip_acty_ref_perd_cd
5334: ,nvl(cur.precision,2)
5335: from ben_pl_f pl
5336: ,fnd_currencies cur
5337: where pl.pl_id = p_pl_id
5338: and p_effective_date between pl.effective_start_date
5339: and pl.effective_end_date

Line 5516: lv_pl_name ben_pl_f.name%TYPE;

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

Line 5540: ben_pl_f pl,

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

Line 5563: ben_pl_f pl,

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

Line 5586: ben_pl_f pl,

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

Line 5615: ben_pl_f pl,

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