DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_NO_OTHR_CVG_RT_F

Line 484: (rt_no_othr_cvg_flag = 'Y' and exists (select '1' from BEN_NO_OTHR_CVG_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id

480:
481: (rt_othr_ptip_flag = 'Y' and exists (select '1' from BEN_OTHR_PTIP_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
482: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
483:
484: (rt_no_othr_cvg_flag = 'Y' and exists (select '1' from BEN_NO_OTHR_CVG_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
485: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
486:
487: (rt_dpnt_othr_ptip_flag = 'Y' and exists (select '1' from BEN_DPNT_OTHR_PTIP_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
488: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or