APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 1226: ,ben_elig_cvrd_dpnt_f pdp

1222: --
1223: cursor c_chk_cvrd is
1224: select null
1225: from ben_prtt_enrt_rslt_f pen
1226: ,ben_elig_cvrd_dpnt_f pdp
1227: where pdp.dpnt_person_id = p_person_id
1228: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1229: and pen.prtt_enrt_rslt_stat_cd is null
1230: and pen.pgm_id = nvl(p_pgm_id, pen.pgm_id)

Line 1302: l_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%type;

1298: l_proc varchar2(80) := g_package||'.get_max_enrt_cvg_thru_dt';
1299: l_exists varchar2(1);
1300: l_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type;
1301: l_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type;
1302: l_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%type;
1303: --
1304: cursor c_get_enrt_cvg_thru_dt is
1305: select max(pen.enrt_cvg_thru_dt)
1306: from ben_prtt_enrt_rslt_f pen

Line 1325: from ben_elig_cvrd_dpnt_f pdp

1321: and pen.business_group_id = p_business_group_id;
1322: --
1323: cursor c_get_dpnt_cvg_thru_dt is
1324: select max(pdp.cvg_thru_dt)
1325: from ben_elig_cvrd_dpnt_f pdp
1326: ,ben_prtt_enrt_rslt_f pen
1327: where pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1328: and pen.prtt_enrt_rslt_stat_cd is null
1329: and pdp.dpnt_person_id = p_person_id

Line 2312: from ben_elig_cvrd_dpnt_f pdp

2308: --
2309: cursor c_get_cvrd_dpnt
2310: is
2311: select distinct pdp.dpnt_person_id
2312: from ben_elig_cvrd_dpnt_f pdp
2313: where pdp.per_in_ler_id = p_per_in_ler_id
2314: and p_lf_evt_ocrd_dt
2315: between pdp.effective_start_date and pdp.effective_end_date
2316: and pdp.cvg_thru_dt <> hr_api.g_eot

Line 3060: l_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%type;

3056: l_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;
3057: l_typ_cd ben_ler_f.typ_cd%type;
3058: l_cbr_inelg_rsn_cd ben_cbr_quald_bnf.cbr_inelg_rsn_cd%type;
3059: l_effective_date date;
3060: l_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%type;
3061: l_cbr_quald_bnf_id ben_cbr_quald_bnf.cbr_quald_bnf_id%type;
3062: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;
3063: l_cqb_object_version_number ben_cbr_quald_bnf.object_version_number%type;
3064: l_cqb_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;

Line 3145: from ben_elig_cvrd_dpnt_f pdp

3141: -- Bug 12386329
3142: --
3143: cursor c_get_cvrd_dpnt is
3144: select distinct pdp.dpnt_person_id
3145: from ben_elig_cvrd_dpnt_f pdp
3146: where pdp.per_in_ler_id = p_per_in_ler_id
3147: and l_lf_evt_ocrd_dt
3148: between pdp.effective_start_date and pdp.effective_end_date
3149: and pdp.cvg_thru_dt <> hr_api.g_eot