APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_PGM_F

Line 1137: from ben_pgm_f pgm

1133: l_update boolean := false;
1134: --
1135: cursor c_chk_pgm_typ is
1136: select null
1137: from ben_pgm_f pgm
1138: where pgm.pgm_id = p_pgm_id
1139: and pgm.pgm_typ_cd like 'COBRA%'
1140: and p_effective_date
1141: between pgm.effective_start_date and pgm.effective_end_date

Line 1383: l_pgm_id ben_pgm_f.pgm_id%type;

1379: --
1380: l_proc varchar2(80) := g_package||
1381: '.update_cobra_elig_info';
1382: l_ptip_id ben_ptip_f.ptip_id%type;
1383: l_pgm_id ben_pgm_f.pgm_id%type;
1384: l_cbr_elig_perd_strt_dt ben_cbr_quald_bnf.cbr_elig_perd_strt_dt%type;
1385: l_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%type;
1386: l_old_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%type;
1387: l_cbr_quald_bnf_id ben_cbr_quald_bnf.cbr_quald_bnf_id%type;

Line 1397: ,ben_pgm_f pgm

1393: --
1394: cursor c_get_epe is
1395: select epe.*, pgm.poe_lvl_cd
1396: from ben_elig_per_elctbl_chc epe
1397: ,ben_pgm_f pgm
1398: where epe.per_in_ler_id = p_per_in_ler_id
1399: and epe.business_group_id = p_business_group_id
1400: and epe.pgm_id = pgm.pgm_id
1401: and nvl(p_lf_evt_ocrd_dt, p_effective_date)

Line 1773: l_pgm_id ben_pgm_f.pgm_id%type;

1769:
1770: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1771: l_exists varchar2(1);
1772: l_init_evt boolean := false;
1773: l_pgm_id ben_pgm_f.pgm_id%type;
1774: l_ptip_id ben_ptip_f.ptip_id%type;
1775: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
1776: l_cqb_ptip_id ben_ptip_f.ptip_id%type;
1777: l_poe_lvl_cd ben_pgm_f.poe_lvl_cd%type;

Line 1777: l_poe_lvl_cd ben_pgm_f.poe_lvl_cd%type;

1773: l_pgm_id ben_pgm_f.pgm_id%type;
1774: l_ptip_id ben_ptip_f.ptip_id%type;
1775: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
1776: l_cqb_ptip_id ben_ptip_f.ptip_id%type;
1777: l_poe_lvl_cd ben_pgm_f.poe_lvl_cd%type;
1778: l_enrld_person_id ben_prtt_enrt_rslt_f.person_id%type;
1779: l_proc varchar2(80) := g_package||'.update_dpnt_cobra_info';
1780: l_arra_event boolean;
1781: --

Line 1829: from ben_pgm_f pgm

1825: --
1826: cursor c_get_poe_lvl_cd
1827: is
1828: select pgm.poe_lvl_cd
1829: from ben_pgm_f pgm
1830: where pgm.pgm_id = l_pgm_id
1831: and p_effective_date
1832: between pgm.effective_start_date and pgm.effective_end_date
1833: and pgm.business_group_id = p_business_group_id;

Line 2289: l_pgm_id ben_pgm_f.pgm_id%type;

2285: l_quald_bnf_person_id ben_cbr_quald_bnf.quald_bnf_person_id%type;
2286: l_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%type;
2287: l_enrld boolean := false;
2288: l_exists varchar2(1);
2289: l_pgm_id ben_pgm_f.pgm_id%type;
2290: l_proc varchar2(80) := g_package||'.chk_cobra_eligibility';
2291: --
2292: cursor c_get_cbr_quald_bnf(p_quald_bnf_person_id in number)
2293: is