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 1086: FROM ben_acty_base_rt_f abr

1082: the user. */
1083: AND (
1084: EXISTS
1085: (SELECT NULL
1086: FROM ben_acty_base_rt_f abr
1087: ,ben_acty_vrbl_rt_f avr
1088: ,ben_vrbl_rt_prfl_f vpf
1089: WHERE abr.ptip_id = ctp.ptip_id
1090: AND abr.business_group_id =

Line 1176: FROM ben_acty_base_rt_f abr

1172: by the user. */
1173: AND (
1174: EXISTS
1175: (SELECT NULL
1176: FROM ben_acty_base_rt_f abr
1177: ,ben_acty_vrbl_rt_f avr
1178: ,ben_vrbl_rt_prfl_f vpf
1179: WHERE abr.pl_id = cpp.pl_id
1180: AND abr.business_group_id =

Line 1252: FROM ben_acty_base_rt_f abr

1248: that has been specified by the user. */
1249: AND (
1250: EXISTS
1251: (SELECT NULL
1252: FROM ben_acty_base_rt_f abr
1253: ,ben_acty_vrbl_rt_f avr
1254: ,ben_vrbl_rt_prfl_f vpf
1255: WHERE abr.oipl_id = cop.oipl_id
1256: AND abr.business_group_id =

Line 1281: FROM ben_acty_base_rt_f abr

1277: variable rate profile that has been specified by the user. */
1278: AND (
1279: EXISTS
1280: (SELECT NULL
1281: FROM ben_acty_base_rt_f abr
1282: ,ben_acty_vrbl_rt_f avr
1283: ,ben_vrbl_rt_prfl_f vpf
1284: WHERE abr.pgm_id = pgm.pgm_id
1285: AND abr.business_group_id = pgm.business_group_id

Line 1508: FROM ben_acty_base_rt_f abr

1504: that has been specified by the user. */
1505: AND (
1506: EXISTS
1507: (SELECT NULL
1508: FROM ben_acty_base_rt_f abr
1509: ,ben_acty_vrbl_rt_f avr
1510: ,ben_vrbl_rt_prfl_f vpf
1511: WHERE abr.pl_id = pln.pl_id
1512: AND abr.business_group_id = pln.business_group_id

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

1947: l_tabname_set(16) := 'ben_popl_enrt_typ_cycl_f'; --
1948: --
1949: l_tabname_set(17) := 'ben_vrbl_rt_prfl_f';
1950: l_tabname_set(18) := 'ben_acty_vrbl_rt_f';
1951: l_tabname_set(19) := 'ben_acty_base_rt_f';
1952: l_tabname_set(20) := 'ben_actl_prem_vrbl_rt_f';
1953: l_tabname_set(21) := 'ben_actl_prem_f';
1954: l_tabname_set(22) := 'ben_bnft_vrbl_rt_f';
1955: l_tabname_set(23) := 'ben_cvg_amt_calc_mthd_f';