DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_VRBL_RT_PRFL_RL_F

Line 393: (rt_prfl_rl_flag = 'Y' and exists (select '1' from BEN_VRBL_RT_PRFL_RL_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id

389:
390: (rt_py_bss_flag = 'Y' and exists (select '1' from BEN_PY_BSS_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
391: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
392:
393: (rt_prfl_rl_flag = 'Y' and exists (select '1' from BEN_VRBL_RT_PRFL_RL_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
394: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
395:
396: (rt_cmbn_age_los_flag = 'Y' and exists (select '1' from BEN_CMBN_AGE_LOS_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
397: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or