APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PL_BNF_CTFN_PRVDD_F

Line 1429: from ben_pl_bnf_ctfn_prvdd_f pbc,

1425: ccp.effective_start_date and ccp.effective_end_date;
1426: --
1427: cursor c_pbc(p_prtt_enrt_actn_id number) is
1428: select max(pbc.bnf_ctfn_recd_dt) ctfn_recd_dt
1429: from ben_pl_bnf_ctfn_prvdd_f pbc,
1430: ben_prtt_enrt_actn_f pea
1431: where pbc.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1432: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1433: and pbc.pl_bnf_id = pea.pl_bnf_id

Line 2044: from ben_pl_bnf_ctfn_prvdd_f pbc

2040: sum(decode(pbc.bnf_ctfn_rqd_flag,'Y',1,0)) tot_rqd,
2041: sum(decode(pbc.bnf_ctfn_recd_dt,null,1,0)) tot_open_ctfn,
2042: sum(decode(pbc.bnf_ctfn_rqd_flag,'N',0,
2043: decode(pbc.bnf_ctfn_recd_dt,null,1,0))) tot_open_rqd
2044: from ben_pl_bnf_ctfn_prvdd_f pbc
2045: where pbc.prtt_enrt_actn_id = p_prtt_enrt_actn_id
2046: and pbc.pl_bnf_id = p_pl_bnf_id
2047: and p_effective_date between
2048: pbc.effective_start_date and pbc.effective_end_date;

Line 7468: -- ben_pl_bnf_ctfn_prvdd_f

7464: ,p_object_version_number out nocopy number
7465: ,p_pl_bnf_ctfn_prvdd_id out nocopy number) is
7466: --
7467: -- this procedure writes a beneficiary certification to
7468: -- ben_pl_bnf_ctfn_prvdd_f
7469: --
7470: l_proc varchar2(80);
7471: l_effective_start_date date;
7472: l_effective_end_date date;

Line 7578: from ben_pl_bnf_ctfn_prvdd_f

7574: pl.effective_start_date and pl.effective_end_date;
7575: --
7576: cursor c_ctfns_exist(v_pl_bnf_id number) is
7577: select 's'
7578: from ben_pl_bnf_ctfn_prvdd_f
7579: where pl_bnf_id = v_pl_bnf_id
7580: and p_effective_date between effective_start_date
7581: and effective_end_date
7582: and business_group_id = p_business_group_id;

Line 8198: -- exist for the person in ben_pl_bnf_ctfn_prvdd_f.

8194: hr_utility.set_location('Ctfn rqmts not met', 10);
8195: end if;
8196: --
8197: -- Ctfn rqmts are not met or no ctfns were found. Check if ctfns
8198: -- exist for the person in ben_pl_bnf_ctfn_prvdd_f.
8199: --
8200: open c_ctfns_exist(l_dsgn_bnf.pl_bnf_id);
8201: fetch c_ctfns_exist into l_dummy;
8202: --

Line 8819: from ben_pl_bnf_ctfn_prvdd_f

8815: -- Cursor to check if the NSC ctfn has been provided.
8816: --
8817: cursor c_nsc_prvdd(v_pl_bnf_id number) is
8818: select 's'
8819: from ben_pl_bnf_ctfn_prvdd_f
8820: where pl_bnf_id = v_pl_bnf_id
8821: and bnf_ctfn_recd_dt is not null
8822: and business_group_id = p_business_group_id
8823: and p_effective_date between effective_start_date