APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PL_BNF_CTFN_PRVDD_F

Line 1442: from ben_pl_bnf_ctfn_prvdd_f pbc,

1438: ccp.effective_start_date and ccp.effective_end_date;
1439: --
1440: cursor c_pbc(p_prtt_enrt_actn_id number) is
1441: select max(pbc.bnf_ctfn_recd_dt) ctfn_recd_dt
1442: from ben_pl_bnf_ctfn_prvdd_f pbc,
1443: ben_prtt_enrt_actn_f pea
1444: where pbc.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1445: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1446: and pbc.pl_bnf_id = pea.pl_bnf_id

Line 2057: from ben_pl_bnf_ctfn_prvdd_f pbc

2053: sum(decode(pbc.bnf_ctfn_rqd_flag,'Y',1,0)) tot_rqd,
2054: sum(decode(pbc.bnf_ctfn_recd_dt,null,1,0)) tot_open_ctfn,
2055: sum(decode(pbc.bnf_ctfn_rqd_flag,'N',0,
2056: decode(pbc.bnf_ctfn_recd_dt,null,1,0))) tot_open_rqd
2057: from ben_pl_bnf_ctfn_prvdd_f pbc
2058: where pbc.prtt_enrt_actn_id = p_prtt_enrt_actn_id
2059: and pbc.pl_bnf_id = p_pl_bnf_id
2060: and p_effective_date between
2061: pbc.effective_start_date and pbc.effective_end_date;

Line 7553: -- ben_pl_bnf_ctfn_prvdd_f

7549: ,p_object_version_number out nocopy number
7550: ,p_pl_bnf_ctfn_prvdd_id out nocopy number) is
7551: --
7552: -- this procedure writes a beneficiary certification to
7553: -- ben_pl_bnf_ctfn_prvdd_f
7554: --
7555: l_proc varchar2(80);
7556: l_effective_start_date date;
7557: l_effective_end_date date;

Line 7663: from ben_pl_bnf_ctfn_prvdd_f

7659: pl.effective_start_date and pl.effective_end_date;
7660: --
7661: cursor c_ctfns_exist(v_pl_bnf_id number) is
7662: select 's'
7663: from ben_pl_bnf_ctfn_prvdd_f
7664: where pl_bnf_id = v_pl_bnf_id
7665: and p_effective_date between effective_start_date
7666: and effective_end_date
7667: and business_group_id = p_business_group_id;

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

8279: hr_utility.set_location('Ctfn rqmts not met', 10);
8280: end if;
8281: --
8282: -- Ctfn rqmts are not met or no ctfns were found. Check if ctfns
8283: -- exist for the person in ben_pl_bnf_ctfn_prvdd_f.
8284: --
8285: open c_ctfns_exist(l_dsgn_bnf.pl_bnf_id);
8286: fetch c_ctfns_exist into l_dummy;
8287: --

Line 8904: from ben_pl_bnf_ctfn_prvdd_f

8900: -- Cursor to check if the NSC ctfn has been provided.
8901: --
8902: cursor c_nsc_prvdd(v_pl_bnf_id number) is
8903: select 's'
8904: from ben_pl_bnf_ctfn_prvdd_f
8905: where pl_bnf_id = v_pl_bnf_id
8906: and bnf_ctfn_recd_dt is not null
8907: and business_group_id = p_business_group_id
8908: and p_effective_date between effective_start_date