APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_CVRD_DPNT_CTFN_PRVDD_F

Line 1229: -- ben_cvrd_dpnt_ctfn_prvdd_f

1225: ,p_object_version_number out nocopy number
1226: ,p_cvrd_dpnt_ctfn_prvdd_id out nocopy number) is
1227: --
1228: -- this procedure writes a dependent certification to
1229: -- ben_cvrd_dpnt_ctfn_prvdd_f
1230: --
1231: l_proc varchar2(80);
1232: l_effective_start_date date;
1233: l_effective_end_date date;

Line 1430: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,

1426: pcs.effective_start_date and pcs.effective_end_date;
1427: --
1428: cursor c_ccp(p_prtt_enrt_actn_id number) is
1429: select max(ccp.dpnt_dsgn_ctfn_recd_dt) ctfn_recd_dt
1430: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
1431: ben_prtt_enrt_actn_f pea
1432: where ccp.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1433: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1434: and ccp.elig_cvrd_dpnt_id = pea.elig_cvrd_dpnt_id

Line 1901: from ben_elig_cvrd_dpnt_f ecd, ben_cvrd_dpnt_ctfn_prvdd_f prv,

1897: --
1898: cursor c_dpnt_ctfn_prvdd is
1899: select prv.cvrd_dpnt_ctfn_prvdd_id,
1900: prv.object_version_number
1901: from ben_elig_cvrd_dpnt_f ecd, ben_cvrd_dpnt_ctfn_prvdd_f prv,
1902: ben_per_in_ler pil
1903: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1904: and ecd.cvg_strt_dt is not null
1905: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 2045: from ben_cvrd_dpnt_ctfn_prvdd_f ccp

2041: sum(decode(ccp.dpnt_dsgn_ctfn_rqd_flag,'Y',1,0)) tot_rqd,
2042: sum(decode(ccp.dpnt_dsgn_ctfn_recd_dt,null,1,0)) tot_open_ctfn,
2043: sum(decode(ccp.dpnt_dsgn_ctfn_rqd_flag,'N',0,
2044: decode(ccp.dpnt_dsgn_ctfn_recd_dt,null,1,0))) tot_open_rqd
2045: from ben_cvrd_dpnt_ctfn_prvdd_f ccp
2046: where ccp.prtt_enrt_actn_id = p_prtt_enrt_actn_id
2047: and ccp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
2048: and p_effective_date between
2049: ccp.effective_start_date and ccp.effective_end_date;

Line 3425: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,

3421: select ccp.elig_cvrd_dpnt_id,
3422: ccp.dpnt_dsgn_ctfn_typ_cd,
3423: ccp.dpnt_dsgn_ctfn_rqd_flag,
3424: ccp.dpnt_dsgn_ctfn_recd_dt
3425: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
3426: ben_elig_cvrd_dpnt_f ecd,
3427: ben_per_in_ler pil
3428: where ccp.elig_cvrd_dpnt_id = cl_dpnt_id
3429: and ccp.dpnt_dsgn_ctfn_recd_dt IS NULL