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 1073: ,ben_vrbl_rt_prfl_f vpf

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

Line 1163: ,ben_vrbl_rt_prfl_f vpf

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

Line 1239: ,ben_vrbl_rt_prfl_f vpf

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

Line 1268: ,ben_vrbl_rt_prfl_f vpf

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

Line 1495: ,ben_vrbl_rt_prfl_f vpf

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

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

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