APPS.BEN_GLOBAL_ENRT dependencies on BEN_PRTT_ENRT_RSLT_F

Line 319: (p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype) is

315: ------------------------------------------------------------------------------
316: -- clear_pen
317: ------------------------------------------------------------------------------
318: procedure clear_pen
319: (p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype) is
320:
321: l_proc varchar2(80) := g_package||'clear_pen';
322: l_pen_rec ben_prtt_enrt_rslt_f%rowtype;
323:

Line 322: l_pen_rec ben_prtt_enrt_rslt_f%rowtype;

318: procedure clear_pen
319: (p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype) is
320:
321: l_proc varchar2(80) := g_package||'clear_pen';
322: l_pen_rec ben_prtt_enrt_rslt_f%rowtype;
323:
324: begin
325: hr_utility.set_location('Entering '||l_proc,10);
326:

Line 338: ,p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype) is

334: ------------------------------------------------------------------------------
335: procedure get_pen
336: (p_prtt_enrt_rslt_id in number
337: ,p_effective_date in date
338: ,p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype) is
339:
340: l_proc varchar2(80) := g_package||'get_pen';
341:
342: cursor c1 is

Line 344: from ben_prtt_enrt_rslt_f pen

340: l_proc varchar2(80) := g_package||'get_pen';
341:
342: cursor c1 is
343: select pen.*
344: from ben_prtt_enrt_rslt_f pen
345: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
346: and pen.prtt_enrt_rslt_stat_cd is null
347: and p_effective_date between
348: pen.effective_start_date and pen.effective_end_date;

Line 350: l_pen_rec ben_prtt_enrt_rslt_f%rowtype;

346: and pen.prtt_enrt_rslt_stat_cd is null
347: and p_effective_date between
348: pen.effective_start_date and pen.effective_end_date;
349:
350: l_pen_rec ben_prtt_enrt_rslt_f%rowtype;
351:
352: begin
353: hr_utility.set_location('Entering '||l_proc,10);
354: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 378: ,p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype) is

374: ,p_pgm_id in number
375: ,p_pl_id in number
376: ,p_oipl_id in number
377: ,p_effective_date in date
378: ,p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype) is
379:
380: l_proc varchar2(80) := g_package||'get_pen_o';
381:
382: cursor c1 is

Line 384: from ben_prtt_enrt_rslt_f pen

380: l_proc varchar2(80) := g_package||'get_pen_o';
381:
382: cursor c1 is
383: select pen.*
384: from ben_prtt_enrt_rslt_f pen
385: where pen.per_in_ler_id = p_per_in_ler_id and
386: pen.pl_id=p_pl_id
387: and nvl(pen.pgm_id,-1)=nvl(p_pgm_id,-1)
388: and nvl(pen.oipl_id,-1)=nvl(p_oipl_id,-1)

Line 394: l_pen_rec ben_prtt_enrt_rslt_f%rowtype;

390: and p_effective_date
391: between pen.effective_start_date
392: and pen.effective_end_date;
393:
394: l_pen_rec ben_prtt_enrt_rslt_f%rowtype;
395:
396: begin
397: hr_utility.set_location('Entering '||l_proc,10);
398:

Line 419: ,p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype) is

415: ------------------------------------------------------------------------------
416: procedure reload_pen
417: (p_prtt_enrt_rslt_id in number
418: ,p_effective_date in date
419: ,p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype) is
420:
421: l_proc varchar2(80) := g_package||'reload_pen';
422:
423: