APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ENRT_PREM

Line 412: from ben_enrt_prem

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

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

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

Line 1374: ben_enrt_prem_api.update_enrt_prem

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

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

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