DBA Data[Home] [Help]

APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_VRBL_RT_PRFL_F

Line 4039: ben_vrbl_rt_prfl_f vrp

4035: select apr.actl_prem_id,
4036: max(apr.last_update_date) mxapr_lud,
4037: max(vrp.last_update_date) mxvrp_lud
4038: from ben_actl_prem_vrbl_rt_f apr,
4039: ben_vrbl_rt_prfl_f vrp
4040: where vrp.vrbl_rt_prfl_stat_cd = 'A'
4041: and c_eff_date
4042: between vrp.effective_start_date and vrp.effective_end_date
4043: and apr.actl_prem_id = c_apr_id

Line 4743: ben_vrbl_rt_prfl_f vrp

4739: is
4740: select vrp.vrbl_rt_prfl_id,
4741: vrp.mlt_cd
4742: from ben_acty_vrbl_rt_f avr,
4743: ben_vrbl_rt_prfl_f vrp
4744: where vrp.vrbl_rt_prfl_stat_cd = 'A'
4745: and c_eff_date
4746: between vrp.effective_start_date
4747: and vrp.effective_end_date