APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_PTIP_F

Line 503: from ben_ptip_f

499: --
500: -- RCHASE wwbug 1480395 fetch pgm_id, if necessary for formula context
501: cursor c_pgm_ptip is
502: select pgm_id
503: from ben_ptip_f
504: where ptip_id = p_ptip_id
505: and p_effective_date between effective_start_date
506: and effective_end_date;
507: --

Line 1364: l_ptip_id ben_ptip_f.ptip_id%type;

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

Line 1686: l_ptip_id ben_ptip_f.ptip_id%type;

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

Line 1688: l_cqb_ptip_id ben_ptip_f.ptip_id%type;

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