DBA Data[Home] [Help]

APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_ACTL_PREM_VRBL_RT_F

Line 4038: from ben_actl_prem_vrbl_rt_f apr,

4034: is
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