APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 151: from ben_pil_elctbl_chc_popl pel

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

Line 294: from ben_pil_elctbl_chc_popl

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

Line 299: from ben_pil_elctbl_chc_popl

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

Line 309: from ben_pil_elctbl_chc_popl pel

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

Line 661: delete from ben_pil_elctbl_chc_popl pel

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