377:
378: (rt_org_unit_flag = 'Y' and exists (select '1' from BEN_ORG_UNIT_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
379: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
380:
381: (rt_loa_rsn_flag = 'Y' and exists (select '1' from BEN_LOA_RSN_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
382: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
383:
384: (rt_pyrl_flag = 'Y' and exists (select '1' from BEN_PYRL_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
385: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or