APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_ACTY_BASE_RT_F

Line 78: ben_acty_base_rt_f abr

74: sum(decode(vpf.rt_hrs_wkd_flag,''Y'',1,0)),
75: sum(decode(vpf.rt_cmbn_age_los_flag,''Y'',1,0))
76: from ben_vrbl_rt_prfl_f vpf,
77: ben_acty_vrbl_rt_f avr,
78: ben_acty_base_rt_f abr
79: where abr.{OBJECT} = :cobj_id
80: and abr.business_group_id = :business_group_id
81: and :abr_effective_date
82: between abr.effective_start_date

Line 1071: FROM ben_acty_base_rt_f abr

1067: the user. */
1068: AND (
1069: EXISTS
1070: (SELECT NULL
1071: FROM ben_acty_base_rt_f abr
1072: ,ben_acty_vrbl_rt_f avr
1073: ,ben_vrbl_rt_prfl_f vpf
1074: WHERE abr.ptip_id = ctp.ptip_id
1075: AND abr.business_group_id =

Line 1161: FROM ben_acty_base_rt_f abr

1157: by the user. */
1158: AND (
1159: EXISTS
1160: (SELECT NULL
1161: FROM ben_acty_base_rt_f abr
1162: ,ben_acty_vrbl_rt_f avr
1163: ,ben_vrbl_rt_prfl_f vpf
1164: WHERE abr.pl_id = cpp.pl_id
1165: AND abr.business_group_id =

Line 1237: FROM ben_acty_base_rt_f abr

1233: that has been specified by the user. */
1234: AND (
1235: EXISTS
1236: (SELECT NULL
1237: FROM ben_acty_base_rt_f abr
1238: ,ben_acty_vrbl_rt_f avr
1239: ,ben_vrbl_rt_prfl_f vpf
1240: WHERE abr.oipl_id = cop.oipl_id
1241: AND abr.business_group_id =

Line 1266: FROM ben_acty_base_rt_f abr

1262: variable rate profile that has been specified by the user. */
1263: AND (
1264: EXISTS
1265: (SELECT NULL
1266: FROM ben_acty_base_rt_f abr
1267: ,ben_acty_vrbl_rt_f avr
1268: ,ben_vrbl_rt_prfl_f vpf
1269: WHERE abr.pgm_id = pgm.pgm_id
1270: AND abr.business_group_id = pgm.business_group_id

Line 1493: FROM ben_acty_base_rt_f abr

1489: that has been specified by the user. */
1490: AND (
1491: EXISTS
1492: (SELECT NULL
1493: FROM ben_acty_base_rt_f abr
1494: ,ben_acty_vrbl_rt_f avr
1495: ,ben_vrbl_rt_prfl_f vpf
1496: WHERE abr.pl_id = pln.pl_id
1497: AND abr.business_group_id = pln.business_group_id

Line 1933: l_tabname_set(19) := 'ben_acty_base_rt_f';

1929: l_tabname_set(16) := 'ben_popl_enrt_typ_cycl_f'; --
1930: --
1931: l_tabname_set(17) := 'ben_vrbl_rt_prfl_f';
1932: l_tabname_set(18) := 'ben_acty_vrbl_rt_f';
1933: l_tabname_set(19) := 'ben_acty_base_rt_f';
1934: l_tabname_set(20) := 'ben_actl_prem_vrbl_rt_f';
1935: l_tabname_set(21) := 'ben_actl_prem_f';
1936: l_tabname_set(22) := 'ben_bnft_vrbl_rt_f';
1937: l_tabname_set(23) := 'ben_cvg_amt_calc_mthd_f';