eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_GLOBAL_FUNCTIONS dependencies on BEN_GLOBAL_FUNCTIONS

Line 1: package body ben_global_functions as

1: package body ben_global_functions as
2: /* $Header: beglbfnc.pkb 120.1 2006/05/02 07:09:16 rbingi noship $ */
3: --
4: /*
5: +==============================================================================+

Line 22: g_package varchar2(50) := 'ben_global_functions.';

18: */
19: --
20: -- Globals.
21: --
22: g_package varchar2(50) := 'ben_global_functions.';
23: --
24: function is_plnip_related
25: (p_pl_id in number
26: ,p_oipl_id in number

Line 382: l_return := ben_global_functions.get_par_pgm_id

378: close c_abr;
379: --
380: if p_acty_base_rt_id is not null then
381: --
382: l_return := ben_global_functions.get_par_pgm_id
383: (p_pgm_id => l_abr_row.pgm_id
384: ,p_ptip_id => l_abr_row.ptip_id
385: ,p_pl_id => l_abr_row.pl_id
386: ,p_plip_id => l_abr_row.plip_id

Line 432: l_return := ben_global_functions.get_par_plnip_id

428: close c_abr;
429: --
430: if p_acty_base_rt_id is not null then
431: --
432: l_return := ben_global_functions.get_par_plnip_id
433: (p_pl_id => l_abr_row.pl_id
434: ,p_oipl_id => l_abr_row.oipl_id
435: );
436: --

Line 473: l_return := ben_global_functions.get_abr_par_pgm_id

469: close c_ecr;
470: --
471: if p_enrt_rt_id is not null then
472: --
473: l_return := ben_global_functions.get_abr_par_pgm_id
474: (p_acty_base_rt_id => l_abr_id
475: );
476: --
477: end if;

Line 491: select ben_global_functions.get_par_pgm_id

487: )
488: return number
489: is
490: cursor c_get_rt_par_pgmpl_id(p_vpf_id number) is
491: select ben_global_functions.get_par_pgm_id
492: (abr.pgm_id,abr.ptip_id,abr.pl_id,abr.plip_id,abr.oipl_id,abr.oiplip_id,abr.opt_id) pgm_id,
493: ben_global_functions.get_par_plnip_id(abr.pl_id,abr.oipl_id,abr.opt_id) nip_id
494: from ben_acty_vrbl_rt_f avr
495: , ben_acty_base_rt_f abr

Line 493: ben_global_functions.get_par_plnip_id(abr.pl_id,abr.oipl_id,abr.opt_id) nip_id

489: is
490: cursor c_get_rt_par_pgmpl_id(p_vpf_id number) is
491: select ben_global_functions.get_par_pgm_id
492: (abr.pgm_id,abr.ptip_id,abr.pl_id,abr.plip_id,abr.oipl_id,abr.oiplip_id,abr.opt_id) pgm_id,
493: ben_global_functions.get_par_plnip_id(abr.pl_id,abr.oipl_id,abr.opt_id) nip_id
494: from ben_acty_vrbl_rt_f avr
495: , ben_acty_base_rt_f abr
496: where avr.vrbl_rt_prfl_id = p_vpf_id
497: and avr.acty_base_rt_id = abr.acty_base_rt_id

Line 503: select ben_global_functions.get_par_pgm_id

499: and avr.effective_start_date between abr.effective_start_date
500: and abr.effective_end_date;
501: --
502: cursor c_get_cvg_par_pgmpl_id(p_vpf_id number) is
503: select ben_global_functions.get_par_pgm_id
504: (null,null,ccm.pl_id,ccm.plip_id,ccm.oipl_id,null) pgm_id,
505: ben_global_functions.get_par_plnip_id(ccm.pl_id,ccm.oipl_id) nip_id
506: from ben_bnft_vrbl_rt_f bvr
507: , ben_cvg_amt_calc_mthd_f ccm

Line 505: ben_global_functions.get_par_plnip_id(ccm.pl_id,ccm.oipl_id) nip_id

501: --
502: cursor c_get_cvg_par_pgmpl_id(p_vpf_id number) is
503: select ben_global_functions.get_par_pgm_id
504: (null,null,ccm.pl_id,ccm.plip_id,ccm.oipl_id,null) pgm_id,
505: ben_global_functions.get_par_plnip_id(ccm.pl_id,ccm.oipl_id) nip_id
506: from ben_bnft_vrbl_rt_f bvr
507: , ben_cvg_amt_calc_mthd_f ccm
508: where bvr.vrbl_rt_prfl_id = p_vpf_id
509: and bvr.cvg_amt_calc_mthd_id = ccm.cvg_amt_calc_mthd_id

Line 514: select ben_global_functions.get_par_pgm_id

510: and bvr.effective_start_date between ccm.effective_start_date
511: and ccm.effective_end_date;
512: --
513: cursor c_get_acp_par_pgmpl_id(p_vpf_id number) is
514: select ben_global_functions.get_par_pgm_id
515: (null,null,apr.pl_id,null,apr.oipl_id,null) pgm_id,
516: ben_global_functions.get_par_plnip_id(apr.pl_id,apr.oipl_id) pl_id
517: from ben_actl_prem_vrbl_rt_f apv
518: , ben_actl_prem_f apr

Line 516: ben_global_functions.get_par_plnip_id(apr.pl_id,apr.oipl_id) pl_id

512: --
513: cursor c_get_acp_par_pgmpl_id(p_vpf_id number) is
514: select ben_global_functions.get_par_pgm_id
515: (null,null,apr.pl_id,null,apr.oipl_id,null) pgm_id,
516: ben_global_functions.get_par_plnip_id(apr.pl_id,apr.oipl_id) pl_id
517: from ben_actl_prem_vrbl_rt_f apv
518: , ben_actl_prem_f apr
519: where apv.vrbl_rt_prfl_id = p_vpf_id
520: and apv.actl_prem_id = apr.actl_prem_id

Line 606: end ben_global_functions;

602: return l_return;
603: --
604: end round_monetary_value;
605: --
606: end ben_global_functions;