APPS.BEN_GLOBAL_ENRT dependencies on BEN_PRTT_ENRT_RSLT_F

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

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

Line 319: l_pen_rec ben_prtt_enrt_rslt_f%rowtype;

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

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

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

Line 341: from ben_prtt_enrt_rslt_f pen

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

Line 347: l_pen_rec ben_prtt_enrt_rslt_f%rowtype;

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

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

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

Line 381: from ben_prtt_enrt_rslt_f pen

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

Line 391: l_pen_rec ben_prtt_enrt_rslt_f%rowtype;

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

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

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