APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ELIG_DPNT

Line 427: from ben_elig_dpnt

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

Line 557: delete from ben_elig_dpnt

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

Line 1281: ben_ELIG_DPNT_api.update_perf_ELIG_DPNT

1277: end loop;
1278: --
1279: end if;
1280: --
1281: ben_ELIG_DPNT_api.update_perf_ELIG_DPNT
1282: (p_elig_dpnt_id => p_elig_dpnt_id
1283: ,p_create_dt => p_create_dt
1284: ,p_business_group_id => p_business_group_id
1285: ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id

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

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