APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ENRT_PREM

Line 410: from ben_enrt_prem

406: ,ELIG_PER_ELCTBL_CHC_ID
407: ,ENRT_BNFT_ID
408: ,OBJECT_VERSION_NUMBER
409: ,null mark_delete
410: from ben_enrt_prem
411: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
412: --
413: cursor c_egd_ch (p_elig_per_elctbl_chc_id number) is
414: select elig_dpnt_id

Line 1368: update ben_enrt_prem set val = p_val, uom=p_uom

1364: end if;
1365: --
1366: hr_utility.set_location('Obj version'||l_object_version_number,10);
1367: --
1368: update ben_enrt_prem set val = p_val, uom=p_uom
1369: where enrt_prem_id = p_enrt_prem_id;
1370: /*
1371: ben_enrt_prem_api.update_enrt_prem
1372: (p_enrt_prem_id => p_enrt_prem_id

Line 1371: ben_enrt_prem_api.update_enrt_prem

1367: --
1368: update ben_enrt_prem set val = p_val, uom=p_uom
1369: where enrt_prem_id = p_enrt_prem_id;
1370: /*
1371: ben_enrt_prem_api.update_enrt_prem
1372: (p_enrt_prem_id => p_enrt_prem_id
1373: ,p_val => p_val
1374: ,p_uom => p_uom
1375: ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id

Line 1847: delete from ben_enrt_prem where enrt_prem_id = g_unrest_epr_instance(i).enrt_prem_id;

1843: for i in g_unrest_epr_instance.first..g_unrest_epr_instance.last loop
1844: --
1845: if g_unrest_epr_instance(i).mark_delete is null then
1846: --
1847: delete from ben_enrt_prem where enrt_prem_id = g_unrest_epr_instance(i).enrt_prem_id;
1848: --
1849: end if;
1850: --
1851: end loop;