APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 1208: ,ben_elig_cvrd_dpnt_f pdp

1204: --
1205: cursor c_chk_cvrd is
1206: select null
1207: from ben_prtt_enrt_rslt_f pen
1208: ,ben_elig_cvrd_dpnt_f pdp
1209: where pdp.dpnt_person_id = p_person_id
1210: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1211: and pen.prtt_enrt_rslt_stat_cd is null
1212: and pen.pgm_id = nvl(p_pgm_id, pen.pgm_id)

Line 1284: l_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%type;

1280: l_proc varchar2(80) := g_package||'.get_max_enrt_cvg_thru_dt';
1281: l_exists varchar2(1);
1282: l_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type;
1283: l_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type;
1284: l_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%type;
1285: --
1286: cursor c_get_enrt_cvg_thru_dt is
1287: select max(pen.enrt_cvg_thru_dt)
1288: from ben_prtt_enrt_rslt_f pen

Line 1307: from ben_elig_cvrd_dpnt_f pdp

1303: and pen.business_group_id = p_business_group_id;
1304: --
1305: cursor c_get_dpnt_cvg_thru_dt is
1306: select max(pdp.cvg_thru_dt)
1307: from ben_elig_cvrd_dpnt_f pdp
1308: ,ben_prtt_enrt_rslt_f pen
1309: where pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1310: and pen.prtt_enrt_rslt_stat_cd is null
1311: and pdp.dpnt_person_id = p_person_id

Line 2156: from ben_elig_cvrd_dpnt_f pdp

2152: --
2153: cursor c_get_cvrd_dpnt
2154: is
2155: select distinct pdp.dpnt_person_id
2156: from ben_elig_cvrd_dpnt_f pdp
2157: where pdp.per_in_ler_id = p_per_in_ler_id
2158: and p_lf_evt_ocrd_dt
2159: between pdp.effective_start_date and pdp.effective_end_date
2160: and pdp.cvg_thru_dt <> hr_api.g_eot

Line 2791: l_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%type;

2787: l_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;
2788: l_typ_cd ben_ler_f.typ_cd%type;
2789: l_cbr_inelg_rsn_cd ben_cbr_quald_bnf.cbr_inelg_rsn_cd%type;
2790: l_effective_date date;
2791: l_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%type;
2792: l_cbr_quald_bnf_id ben_cbr_quald_bnf.cbr_quald_bnf_id%type;
2793: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;
2794: l_cqb_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2795: l_cqb_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;