DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_PSTL_ZIP_RT_F

Line 330: (rt_pstl_cd_flag = 'Y' and exists (select '1' from BEN_PSTL_ZIP_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id

326: -- Bug 14361059
327: (rt_hrly_slrd_flag = 'Y' and exists (select '1' from BEN_HRLY_SLRD_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
328: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
329:
330: (rt_pstl_cd_flag = 'Y' and exists (select '1' from BEN_PSTL_ZIP_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
331: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
332:
333: (rt_lbr_mmbr_flag = 'Y' and exists (select '1' from BEN_LBR_MMBR_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
334: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or