DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_DPNT_CVRD_OTHR_PGM_RT_F

Line 460: (rt_dpnt_cvrd_pgm_flag = 'Y' and exists (select '1' from BEN_DPNT_CVRD_OTHR_PGM_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id

456:
457: (rt_dpnt_cvrd_ptip_flag = 'Y' and exists (select '1' from BEN_DPNT_CVRD_OTHR_PTIP_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
458: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
459:
460: (rt_dpnt_cvrd_pgm_flag = 'Y' and exists (select '1' from BEN_DPNT_CVRD_OTHR_PGM_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
461: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
462:
463: (rt_enrld_oipl_flag = 'Y' and exists (select '1' from BEN_ENRLD_ANTHR_OIPL_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
464: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or