DBA Data[Home] [Help]

APPS.BEN_SSPNDD_ENROLLMENT dependencies on BEN_PLIP_F

Line 1007: From ben_plip_f plip, ben_prtt_enrt_rslt_f pen

1003: select 2 order_no
1004: ,plip.DFLT_TO_ASN_PNDG_CTFN_CD
1005: ,plip.DFLT_TO_ASN_PNDG_CTFN_RL
1006: ,plip.BNFT_OR_OPTION_RSTRCTN_CD
1007: From ben_plip_f plip, ben_prtt_enrt_rslt_f pen
1008: Where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1009: and pen.pgm_id = plip.pgm_id
1010: and pen.pl_id = plip.pl_id
1011: and pen.prtt_enrt_rslt_stat_cd is null

Line 3915: ben_plip_f plip

3911: select nvl(lbr.unsspnd_enrt_cd,
3912: nvl(pl.unsspnd_enrt_cd, plip.unsspnd_enrt_cd))
3913: from ben_ler_bnft_rstrn_f lbr,
3914: ben_pl_f pl,
3915: ben_plip_f plip
3916: where
3917: pl.pl_id=l_pen.pl_id
3918: and plip.pl_id(+)=pl.pl_id
3919: and nvl(plip.pgm_id,l_pen.pgm_id)=l_pen.pgm_id