DBA Data[Home] [Help]

APPS.BEN_GLOBAL_FUNCTIONS dependencies on BEN_ACTY_BASE_RT_F

Line 317: from ben_acty_base_rt_f abr

313: (c_abr_id in number
314: )
315: is
316: select null
317: from ben_acty_base_rt_f abr
318: where abr.acty_base_rt_id = c_abr_id
319: and nnmntry_uom is null;
320:
321: l_dummy varchar2(1);

Line 363: from ben_acty_base_rt_f abr

359: abr.pl_id,
360: abr.plip_id,
361: abr.oipl_id,
362: abr.oiplip_id
363: from ben_acty_base_rt_f abr
364: where abr.acty_base_rt_id = c_abr_id;
365:
366: l_abr_row c_abr%rowtype;
367:

Line 413: from ben_acty_base_rt_f abr

409: abr.pl_id,
410: abr.plip_id,
411: abr.oipl_id,
412: abr.oiplip_id
413: from ben_acty_base_rt_f abr
414: where abr.acty_base_rt_id = c_abr_id;
415:
416: l_abr_row c_abr%rowtype;
417:

Line 495: , ben_acty_base_rt_f abr

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
498: and abr.nnmntry_uom is null
499: and avr.effective_start_date between abr.effective_start_date