417:
418: (rt_ttl_prtt_flag = 'Y' and exists (select '1' from BEN_TTL_PRTT_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
419: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
420:
421: (rt_gndr_flag = 'Y' and exists (select '1' from BEN_GNDR_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
422: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
423:
424: (rt_tbco_use_flag = 'Y' and exists (select '1' from BEN_TBCO_USE_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
425: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or