APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_CVRD_DPNT_CTFN_PRVDD_F

Line 1216: -- ben_cvrd_dpnt_ctfn_prvdd_f

1212: ,p_object_version_number out nocopy number
1213: ,p_cvrd_dpnt_ctfn_prvdd_id out nocopy number) is
1214: --
1215: -- this procedure writes a dependent certification to
1216: -- ben_cvrd_dpnt_ctfn_prvdd_f
1217: --
1218: l_proc varchar2(80);
1219: l_effective_start_date date;
1220: l_effective_end_date date;

Line 1417: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,

1413: pcs.effective_start_date and pcs.effective_end_date;
1414: --
1415: cursor c_ccp(p_prtt_enrt_actn_id number) is
1416: select max(ccp.dpnt_dsgn_ctfn_recd_dt) ctfn_recd_dt
1417: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
1418: ben_prtt_enrt_actn_f pea
1419: where ccp.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1420: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1421: and ccp.elig_cvrd_dpnt_id = pea.elig_cvrd_dpnt_id

Line 1888: from ben_elig_cvrd_dpnt_f ecd, ben_cvrd_dpnt_ctfn_prvdd_f prv,

1884: --
1885: cursor c_dpnt_ctfn_prvdd is
1886: select prv.cvrd_dpnt_ctfn_prvdd_id,
1887: prv.object_version_number
1888: from ben_elig_cvrd_dpnt_f ecd, ben_cvrd_dpnt_ctfn_prvdd_f prv,
1889: ben_per_in_ler pil
1890: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1891: and ecd.cvg_strt_dt is not null
1892: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 2032: from ben_cvrd_dpnt_ctfn_prvdd_f ccp

2028: sum(decode(ccp.dpnt_dsgn_ctfn_rqd_flag,'Y',1,0)) tot_rqd,
2029: sum(decode(ccp.dpnt_dsgn_ctfn_recd_dt,null,1,0)) tot_open_ctfn,
2030: sum(decode(ccp.dpnt_dsgn_ctfn_rqd_flag,'N',0,
2031: decode(ccp.dpnt_dsgn_ctfn_recd_dt,null,1,0))) tot_open_rqd
2032: from ben_cvrd_dpnt_ctfn_prvdd_f ccp
2033: where ccp.prtt_enrt_actn_id = p_prtt_enrt_actn_id
2034: and ccp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
2035: and p_effective_date between
2036: ccp.effective_start_date and ccp.effective_end_date;

Line 3412: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,

3408: select ccp.elig_cvrd_dpnt_id,
3409: ccp.dpnt_dsgn_ctfn_typ_cd,
3410: ccp.dpnt_dsgn_ctfn_rqd_flag,
3411: ccp.dpnt_dsgn_ctfn_recd_dt
3412: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
3413: ben_elig_cvrd_dpnt_f ecd,
3414: ben_per_in_ler pil
3415: where ccp.elig_cvrd_dpnt_id = cl_dpnt_id
3416: and ccp.dpnt_dsgn_ctfn_recd_dt IS NULL