DBA Data[Home] [Help]

APPS.BEN_EFC_FUNCTIONS dependencies on BEN_EPE_CACHE

Line 310: ,p_currepe_row out nocopy ben_epe_cache.g_pilepe_inst_row

306: procedure EPEorENB_GetEPEDets
307: (p_elig_per_elctbl_chc_id in number default null
308: ,p_enrt_bnft_id in number default null
309: --
310: ,p_currepe_row out nocopy ben_epe_cache.g_pilepe_inst_row
311: )
312: is
313: --
314: l_proc varchar2(1000) := 'EPEorENB_GetEPEDets';

Line 361: l_currepe_set ben_epe_cache.g_pilepe_inst_tbl;

357: between per.effective_start_date and per.effective_end_date;
358: --
359: l_enbdets c_enbdets%rowtype;
360: --
361: l_currepe_set ben_epe_cache.g_pilepe_inst_tbl;
362: --
363: l_currepe_row ben_epe_cache.g_pilepe_inst_row;
364: --
365: l_business_group_id number;

Line 363: l_currepe_row ben_epe_cache.g_pilepe_inst_row;

359: l_enbdets c_enbdets%rowtype;
360: --
361: l_currepe_set ben_epe_cache.g_pilepe_inst_tbl;
362: --
363: l_currepe_row ben_epe_cache.g_pilepe_inst_row;
364: --
365: l_business_group_id number;
366: l_lf_evt_ocrd_dt date;
367: l_person_id number;

Line 384: ben_epe_cache.EPE_GetEPEDets

380: --
381: l_business_group_id := l_epedets.business_group_id;
382: l_lf_evt_ocrd_dt := l_epedets.lf_evt_ocrd_dt;
383: l_person_id := l_epedets.person_id;
384: ben_epe_cache.EPE_GetEPEDets
385: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
386: ,p_per_in_ler_id => l_epedets.per_in_ler_id
387: ,p_inst_row => l_currepe_row
388: );

Line 405: ben_epe_cache.ENBEPE_GetEPEDets

401: l_per_in_ler_id := l_enbdets.per_in_ler_id;
402: --
403: -- Get the EPE details
404: --
405: ben_epe_cache.ENBEPE_GetEPEDets
406: (p_enrt_bnft_id => p_enrt_bnft_id
407: ,p_per_in_ler_id => l_enbdets.per_in_ler_id
408: ,p_inst_row => l_currepe_row
409: );