APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_PTIP_F

Line 521: from ben_ptip_f

517: --
518: -- RCHASE wwbug 1480395 fetch pgm_id, if necessary for formula context
519: cursor c_pgm_ptip is
520: select pgm_id
521: from ben_ptip_f
522: where ptip_id = p_ptip_id
523: and p_effective_date between effective_start_date
524: and effective_end_date;
525: --

Line 1382: l_ptip_id ben_ptip_f.ptip_id%type;

1378: ,p_validate in boolean default false) is
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;

Line 1774: l_ptip_id ben_ptip_f.ptip_id%type;

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;
1778: l_enrld_person_id ben_prtt_enrt_rslt_f.person_id%type;

Line 1776: l_cqb_ptip_id ben_ptip_f.ptip_id%type;

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;
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;