DBA Data[Home] [Help]

APPS.BEN_SSPNDD_ENROLLMENT dependencies on BEN_PLIP_F

Line 951: From ben_plip_f plip, ben_prtt_enrt_rslt_f pen

947: select 2 order_no
948: ,plip.DFLT_TO_ASN_PNDG_CTFN_CD
949: ,plip.DFLT_TO_ASN_PNDG_CTFN_RL
950: ,plip.BNFT_OR_OPTION_RSTRCTN_CD
951: From ben_plip_f plip, ben_prtt_enrt_rslt_f pen
952: Where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
953: and pen.pgm_id = plip.pgm_id
954: and pen.pl_id = plip.pl_id
955: and pen.prtt_enrt_rslt_stat_cd is null

Line 3746: ben_plip_f plip

3742: select nvl(lbr.unsspnd_enrt_cd,
3743: nvl(pl.unsspnd_enrt_cd, plip.unsspnd_enrt_cd))
3744: from ben_ler_bnft_rstrn_f lbr,
3745: ben_pl_f pl,
3746: ben_plip_f plip
3747: where
3748: pl.pl_id=l_pen.pl_id
3749: and plip.pl_id(+)=pl.pl_id
3750: and nvl(plip.pgm_id,l_pen.pgm_id)=l_pen.pgm_id