DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_OPTD_MDCR_RT_F

Line 433: (rt_optd_mdcr_flag = 'Y' and exists (select '1' from BEN_OPTD_MDCR_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id

429:
430: (rt_cbr_quald_bnf_flag = 'Y' and exists (select '1' from BEN_CBR_QUALD_BNF_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
431: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
432:
433: (rt_optd_mdcr_flag = 'Y' and exists (select '1' from BEN_OPTD_MDCR_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
434: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
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