APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 269: l_elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%TYPE;

265: l_chc_id number(15);
266: l_elig_flag varchar2(30);
267: l_inelig_rsn_cd varchar2(30);
268: l_exists varchar2(1);
269: l_elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%TYPE;
270: l_cvg_strt_dt date;
271: l_datetrack_mode varchar2(30);
272: l_cvg_end_dt date;
273: l_ler_chg_dpnt_cvg_cd varchar2(30);

Line 1642: l_elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%TYPE;

1638: is
1639: --
1640: l_proc varchar2(80):= g_package||'.p_upd_egd_with_epe_id';
1641: l_chc_id number(15);
1642: l_elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%TYPE;
1643: --
1644: -- Formula stuff
1645: --
1646: l_outputs ff_exec.outputs_t;

Line 1665: from ben_elig_per_elctbl_chc chc,

1661: chc.oipl_id,
1662: chc.prtt_enrt_rslt_id,
1663: chc.elctbl_flag,
1664: pel.enrt_perd_id
1665: from ben_elig_per_elctbl_chc chc,
1666: ben_pil_elctbl_chc_popl pel
1667: where chc.elig_per_elctbl_chc_id = l_chc_id
1668: and chc.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id;
1669: --