APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on BEN_PER_IN_LER

Line 331: from ben_per_in_ler

327: --
328: cursor c_per_in_ler
329: is
330: select per_in_ler_id
331: from ben_per_in_ler
332: where person_id = p_person_id
333: and per_in_ler_stat_cd = 'STRTD'
334: and business_group_id = p_business_group_id;
335: --

Line 340: from ben_per_in_ler pil

336: l_per_in_ler_id number;
337: --
338: cursor c_lf_evt_ocrd_dt is
339: select lf_evt_ocrd_dt
340: from ben_per_in_ler pil
341: where pil.per_in_ler_id = l_per_in_ler_id;
342: --
343: l_lf_evt_ocrd_dt date;
344: /* cursor to pick results with coverage calculation method ERL */

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

866: --
867: -- Declare cursors and local variables
868: --
869: l_asnd_lf_evt_dt ben_enrt_perd.asnd_lf_evt_dt%TYPE;
870: -- l_ler_id ben_per_in_ler.ler_id%TYPE;
871: l_exists varchar2(1);
872: l_proc varchar2(72) := g_package||'process_post_enrollment';
873: --
874: -- PB : 5422 :