APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ELCTBL_CHC_CTFN

Line 437: from ben_elctbl_chc_ctfn

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

Line 542: delete from ben_elctbl_chc_ctfn

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

Line 546: delete from ben_elctbl_chc_ctfn

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

Line 1864: delete from ben_elctbl_chc_ctfn where elctbl_chc_ctfn_id =

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