APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 149: from ben_pil_elctbl_chc_popl pel

145: where per_in_ler_id = p_per_in_ler_id
146: and in_pndg_wkflow_flag <> 'Y'
147: and pil_elctbl_chc_popl_id in
148: (select pil_elctbl_chc_popl_id
149: from ben_pil_elctbl_chc_popl pel
150: where pel.per_in_ler_id = p_per_in_ler_id and
151: exists
152: ( select null
153: from ben_elig_per_elctbl_chc epe

Line 292: from ben_pil_elctbl_chc_popl

288: */
289: --
290: cursor c_pil_popl is
291: select *
292: from ben_pil_elctbl_chc_popl
293: where per_in_ler_id = p_rec.per_in_ler_id;
294: --
295: cursor c_pl_nip is
296: select null

Line 297: from ben_pil_elctbl_chc_popl

293: where per_in_ler_id = p_rec.per_in_ler_id;
294: --
295: cursor c_pl_nip is
296: select null
297: from ben_pil_elctbl_chc_popl
298: where per_in_ler_id = p_rec.per_in_ler_id
299: and pl_id is not null;
300: --
301: cursor c_epe(p_per_in_ler_id number) is

Line 307: from ben_pil_elctbl_chc_popl pel

303: from ben_elig_per_elctbl_chc epe
304: where epe.per_in_ler_id = p_per_in_ler_id
305: and epe.pil_elctbl_chc_popl_id in
306: (select pel.pil_elctbl_chc_popl_id
307: from ben_pil_elctbl_chc_popl pel
308: where pel.per_in_ler_id = p_per_in_ler_id
309: and not exists
310: (select null
311: from ben_elig_per_elctbl_chc epe2

Line 659: delete from ben_pil_elctbl_chc_popl pel

655: end loop;
656:
657: end if;
658: --
659: delete from ben_pil_elctbl_chc_popl pel
660: where per_in_ler_id = p_rec.per_in_ler_id
661: and not exists
662: (select null
663: from ben_elig_per_elctbl_chc epe