APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_PGM_F

Line 1119: from ben_pgm_f pgm

1115: l_update boolean := false;
1116: --
1117: cursor c_chk_pgm_typ is
1118: select null
1119: from ben_pgm_f pgm
1120: where pgm.pgm_id = p_pgm_id
1121: and pgm.pgm_typ_cd like 'COBRA%'
1122: and p_effective_date
1123: between pgm.effective_start_date and pgm.effective_end_date

Line 1365: l_pgm_id ben_pgm_f.pgm_id%type;

1361: --
1362: l_proc varchar2(80) := g_package||
1363: '.update_cobra_elig_info';
1364: l_ptip_id ben_ptip_f.ptip_id%type;
1365: l_pgm_id ben_pgm_f.pgm_id%type;
1366: l_cbr_elig_perd_strt_dt ben_cbr_quald_bnf.cbr_elig_perd_strt_dt%type;
1367: l_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%type;
1368: l_old_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%type;
1369: l_cbr_quald_bnf_id ben_cbr_quald_bnf.cbr_quald_bnf_id%type;

Line 1378: ,ben_pgm_f pgm

1374: --
1375: cursor c_get_epe is
1376: select epe.*, pgm.poe_lvl_cd
1377: from ben_elig_per_elctbl_chc epe
1378: ,ben_pgm_f pgm
1379: where epe.per_in_ler_id = p_per_in_ler_id
1380: and epe.business_group_id = p_business_group_id
1381: and epe.pgm_id = pgm.pgm_id
1382: and nvl(p_lf_evt_ocrd_dt, p_effective_date)

Line 1685: l_pgm_id ben_pgm_f.pgm_id%type;

1681:
1682: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1683: l_exists varchar2(1);
1684: l_init_evt boolean := false;
1685: l_pgm_id ben_pgm_f.pgm_id%type;
1686: l_ptip_id ben_ptip_f.ptip_id%type;
1687: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
1688: l_cqb_ptip_id ben_ptip_f.ptip_id%type;
1689: l_poe_lvl_cd ben_pgm_f.poe_lvl_cd%type;

Line 1689: l_poe_lvl_cd ben_pgm_f.poe_lvl_cd%type;

1685: l_pgm_id ben_pgm_f.pgm_id%type;
1686: l_ptip_id ben_ptip_f.ptip_id%type;
1687: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
1688: l_cqb_ptip_id ben_ptip_f.ptip_id%type;
1689: l_poe_lvl_cd ben_pgm_f.poe_lvl_cd%type;
1690: l_enrld_person_id ben_prtt_enrt_rslt_f.person_id%type;
1691: l_proc varchar2(80) := g_package||'.update_dpnt_cobra_info';
1692: --
1693: cursor c_get_cbr_quald_bnf

Line 1740: from ben_pgm_f pgm

1736: --
1737: cursor c_get_poe_lvl_cd
1738: is
1739: select pgm.poe_lvl_cd
1740: from ben_pgm_f pgm
1741: where pgm.pgm_id = l_pgm_id
1742: and p_effective_date
1743: between pgm.effective_start_date and pgm.effective_end_date
1744: and pgm.business_group_id = p_business_group_id;

Line 2133: l_pgm_id ben_pgm_f.pgm_id%type;

2129: l_quald_bnf_person_id ben_cbr_quald_bnf.quald_bnf_person_id%type;
2130: l_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%type;
2131: l_enrld boolean := false;
2132: l_exists varchar2(1);
2133: l_pgm_id ben_pgm_f.pgm_id%type;
2134: l_proc varchar2(80) := g_package||'.chk_cobra_eligibility';
2135: --
2136: cursor c_get_cbr_quald_bnf(p_quald_bnf_person_id in number)
2137: is