APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PL_BNF_CTFN_F

Line 7560: from ben_pl_bnf_ctfn_f pl

7556: pl.ctfn_rqd_when_rl ctrrl,
7557: pl.rqd_flag rqd_flag,
7558: pl.rlshp_typ_cd ctrlshcd,
7559: pl.bnf_typ_cd, pl.pl_id
7560: from ben_pl_bnf_ctfn_f pl
7561: where pl.bnf_ctfn_typ_cd <> 'NSC'
7562: and pl.pl_id = v_pl_id
7563: and (pl.rlshp_typ_cd is null or
7564: pl.rlshp_typ_cd in (select contact_type

Line 7606: from ben_pl_bnf_ctfn_f

7602: cursor c_ctfn_defined(v_bnf_person_id number,
7603: v_person_id number,
7604: p_pl_id number) is
7605: select 's'
7606: from ben_pl_bnf_ctfn_f
7607: where bnf_ctfn_typ_cd <> 'NSC'
7608: and pl_id = p_pl_id
7609: and (bnf_typ_cd is null or bnf_typ_cd = 'P')
7610: and (rlshp_typ_cd is null

Line 8717: FROM ben_pl_bnf_ctfn_f pcx

8713: IS
8714: SELECT pcx.rqd_flag ctflag, pcx.bnf_ctfn_typ_cd ctcvgcd,
8715: pcx.ctfn_rqd_when_rl ctrrl, pcx.rlshp_typ_cd ctrlshcd,
8716: pcx.bnf_typ_cd, pcx.pl_id
8717: FROM ben_pl_bnf_ctfn_f pcx
8718: WHERE pcx.pl_id = v_pl_id
8719: AND ( ( NVL (pcx.bnf_typ_cd, 'O') = 'O'
8720: AND v_contact_type = 'O'
8721: AND pcx.rlshp_typ_cd IS NULL