435:
436: (rt_lvg_rsn_flag = 'Y' and exists (select '1' from BEN_LVG_RSN_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
437: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
438:
439: (rt_pstn_flag = 'Y' and exists (select '1' from BEN_PSTN_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
440: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
441:
442: (rt_comptncy_flag = 'Y' and exists (select '1' from BEN_COMPTNCY_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
443: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or