APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ELIG_DPNT

Line 425: from ben_elig_dpnt

421: ,OVRDN_FLAG
422: ,DPNT_PERSON_ID
423: ,OBJECT_VERSION_NUMBER
424: ,null mark_delete
425: from ben_elig_dpnt
426: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
427: --
428: cursor c_ecc_ch (p_elig_per_elctbl_chc_id number) is
429: select elctbl_chc_ctfn_id

Line 555: delete from ben_elig_dpnt

551: delete from ben_enrt_bnft
552: where elig_per_elctbl_chc_id = t_epe_tbl(i);
553:
554: forall i in 1..t_epe_tbl.last
555: delete from ben_elig_dpnt
556: where elig_per_elctbl_chc_id = t_epe_tbl(i);
557:
558: forall i in 1..t_epe_tbl.last
559: delete from ben_elig_per_elctbl_chc

Line 1278: ben_ELIG_DPNT_api.update_perf_ELIG_DPNT

1274: end loop;
1275: --
1276: end if;
1277: --
1278: ben_ELIG_DPNT_api.update_perf_ELIG_DPNT
1279: (p_elig_dpnt_id => p_elig_dpnt_id
1280: ,p_create_dt => p_create_dt
1281: ,p_business_group_id => p_business_group_id
1282: ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id

Line 1890: delete from ben_elig_dpnt where elig_dpnt_id = g_unrest_egd_instance(i).elig_dpnt_id;

1886: for i in g_unrest_egd_instance.first..g_unrest_egd_instance.last loop
1887: --
1888: if g_unrest_egd_instance(i).mark_delete is null then
1889: --
1890: delete from ben_elig_dpnt where elig_dpnt_id = g_unrest_egd_instance(i).elig_dpnt_id;
1891: --
1892: end if;
1893: --
1894: end loop;