APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 267: l_elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%TYPE;

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

Line 1626: l_elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%TYPE;

1622: is
1623: --
1624: l_proc varchar2(80):= g_package||'.p_upd_egd_with_epe_id';
1625: l_chc_id number(15);
1626: l_elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%TYPE;
1627: --
1628: -- Formula stuff
1629: --
1630: l_outputs ff_exec.outputs_t;

Line 1649: from ben_elig_per_elctbl_chc chc,

1645: chc.oipl_id,
1646: chc.prtt_enrt_rslt_id,
1647: chc.elctbl_flag,
1648: pel.enrt_perd_id
1649: from ben_elig_per_elctbl_chc chc,
1650: ben_pil_elctbl_chc_popl pel
1651: where chc.elig_per_elctbl_chc_id = l_chc_id
1652: and chc.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id;
1653: --