APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ELCTBL_CHC_CTFN

Line 435: from ben_elctbl_chc_ctfn

431: ,ELIG_PER_ELCTBL_CHC_ID
432: ,ENRT_BNFT_ID
433: ,OBJECT_VERSION_NUMBER
434: ,null mark_delete
435: from ben_elctbl_chc_ctfn
436: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
437: --
438: --
439: l_dummy varchar2(10);

Line 540: delete from ben_elctbl_chc_ctfn

536: from ben_enrt_bnft
537: where elig_per_elctbl_chc_id = t_epe_tbl(i));
538:
539: forall i in 1..t_epe_tbl.last
540: delete from ben_elctbl_chc_ctfn
541: where elig_per_elctbl_chc_id = t_epe_tbl(i);
542:
543: forall i in 1..t_epe_tbl.last
544: delete from ben_elctbl_chc_ctfn

Line 544: delete from ben_elctbl_chc_ctfn

540: delete from ben_elctbl_chc_ctfn
541: where elig_per_elctbl_chc_id = t_epe_tbl(i);
542:
543: forall i in 1..t_epe_tbl.last
544: delete from ben_elctbl_chc_ctfn
545: where enrt_bnft_id in
546: (select enrt_bnft_id
547: from ben_enrt_bnft
548: where elig_per_elctbl_chc_id = t_epe_tbl(i));

Line 1861: delete from ben_elctbl_chc_ctfn where elctbl_chc_ctfn_id =

1857: for i in g_unrest_ecc_instance.first..g_unrest_ecc_instance.last loop
1858: --
1859: if g_unrest_ecc_instance(i).mark_delete is null then
1860: --
1861: delete from ben_elctbl_chc_ctfn where elctbl_chc_ctfn_id =
1862: g_unrest_ecc_instance(i).elctbl_chc_ctfn_id;
1863: --
1864: end if;
1865: --