APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_VRBL_RT_PRFL_F

Line 76: from ben_vrbl_rt_prfl_f vpf,

72: sum(decode(vpf.rt_comp_lvl_flag,''Y'',1,0)),
73: sum(decode(vpf.rt_pct_fl_tm_flag,''Y'',1,0)),
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

Line 102: from ben_vrbl_rt_prfl_f vpf,

98: sum(decode(vpf.rt_comp_lvl_flag,''Y'',1,0)),
99: sum(decode(vpf.rt_pct_fl_tm_flag,''Y'',1,0)),
100: sum(decode(vpf.rt_hrs_wkd_flag,''Y'',1,0)),
101: sum(decode(vpf.rt_cmbn_age_los_flag,''Y'',1,0))
102: from ben_vrbl_rt_prfl_f vpf,
103: ben_actl_prem_vrbl_rt_f apv,
104: ben_actl_prem_f apr
105: where apr.{OBJECT} = :cobj_id
106: and apr.business_group_id = :business_group_id

Line 128: from ben_vrbl_rt_prfl_f vpf,

124: sum(decode(vpf.rt_comp_lvl_flag,''Y'',1,0)),
125: sum(decode(vpf.rt_pct_fl_tm_flag,''Y'',1,0)),
126: sum(decode(vpf.rt_hrs_wkd_flag,''Y'',1,0)),
127: sum(decode(vpf.rt_cmbn_age_los_flag,''Y'',1,0))
128: from ben_vrbl_rt_prfl_f vpf,
129: ben_bnft_vrbl_rt_f bvr,
130: ben_cvg_amt_calc_mthd_f ccm
131: where ccm.{OBJECT} = :cobj_id
132: and ccm.business_group_id = :business_group_id

Line 1088: ,ben_vrbl_rt_prfl_f vpf

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 =
1091: ctp.business_group_id
1092: AND p_effective_date BETWEEN abr.effective_start_date

Line 1178: ,ben_vrbl_rt_prfl_f vpf

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 =
1181: pgm.business_group_id
1182: AND p_effective_date BETWEEN abr.effective_start_date

Line 1254: ,ben_vrbl_rt_prfl_f vpf

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 =
1257: cop.business_group_id
1258: AND p_effective_date BETWEEN abr.effective_start_date

Line 1283: ,ben_vrbl_rt_prfl_f vpf

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
1286: AND p_effective_date BETWEEN abr.effective_start_date
1287: AND abr.effective_end_date

Line 1510: ,ben_vrbl_rt_prfl_f vpf

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
1513: AND p_effective_date BETWEEN abr.effective_start_date
1514: AND abr.effective_end_date

Line 1949: l_tabname_set(17) := 'ben_vrbl_rt_prfl_f';

1945: l_tabname_set(14) := 'ben_enrt_perd_for_pl_f';
1946: l_tabname_set(15) := 'ben_enrt_perd';
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';