APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on BEN_PER_IN_LER

Line 340: from ben_per_in_ler

336: --
337: cursor c_per_in_ler
338: is
339: select per_in_ler_id
340: from ben_per_in_ler
341: where person_id = p_person_id
342: and per_in_ler_stat_cd = 'STRTD'
343: and business_group_id = p_business_group_id;
344: --

Line 349: from ben_per_in_ler pil

345: l_per_in_ler_id number;
346: --
347: cursor c_lf_evt_ocrd_dt is
348: select lf_evt_ocrd_dt
349: from ben_per_in_ler pil
350: where pil.per_in_ler_id = l_per_in_ler_id;
351: --
352: l_lf_evt_ocrd_dt date;
353: /* cursor to pick results with coverage calculation method ERL */

Line 887: -- l_ler_id ben_per_in_ler.ler_id%TYPE;

883: --
884: -- Declare cursors and local variables
885: --
886: l_asnd_lf_evt_dt ben_enrt_perd.asnd_lf_evt_dt%TYPE;
887: -- l_ler_id ben_per_in_ler.ler_id%TYPE;
888: l_exists varchar2(1);
889: l_proc varchar2(72) := g_package||'process_post_enrollment';
890: --
891: -- PB : 5422 :