APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PL_BNF_CTFN_F

Line 7645: from ben_pl_bnf_ctfn_f pl

7641: pl.ctfn_rqd_when_rl ctrrl,
7642: pl.rqd_flag rqd_flag,
7643: pl.rlshp_typ_cd ctrlshcd,
7644: pl.bnf_typ_cd, pl.pl_id
7645: from ben_pl_bnf_ctfn_f pl
7646: where pl.bnf_ctfn_typ_cd <> 'NSC'
7647: and pl.pl_id = v_pl_id
7648: and (pl.rlshp_typ_cd is null or
7649: pl.rlshp_typ_cd in (select contact_type

Line 7691: from ben_pl_bnf_ctfn_f

7687: cursor c_ctfn_defined(v_bnf_person_id number,
7688: v_person_id number,
7689: p_pl_id number) is
7690: select 's'
7691: from ben_pl_bnf_ctfn_f
7692: where bnf_ctfn_typ_cd <> 'NSC'
7693: and pl_id = p_pl_id
7694: and (bnf_typ_cd is null or bnf_typ_cd = 'P')
7695: and (rlshp_typ_cd is null

Line 8802: FROM ben_pl_bnf_ctfn_f pcx

8798: IS
8799: SELECT pcx.rqd_flag ctflag, pcx.bnf_ctfn_typ_cd ctcvgcd,
8800: pcx.ctfn_rqd_when_rl ctrrl, pcx.rlshp_typ_cd ctrlshcd,
8801: pcx.bnf_typ_cd, pcx.pl_id
8802: FROM ben_pl_bnf_ctfn_f pcx
8803: WHERE pcx.pl_id = v_pl_id
8804: AND ( ( NVL (pcx.bnf_typ_cd, 'O') = 'O'
8805: AND v_contact_type = 'O'
8806: AND pcx.rlshp_typ_cd IS NULL