DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_CNTNG_PRTN_PRFL_RT_F

Line 427: (rt_cntng_prtn_prfl_flag = 'Y' and exists (select '1' from BEN_CNTNG_PRTN_PRFL_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id

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
426:
427: (rt_cntng_prtn_prfl_flag = 'Y' and exists (select '1' from BEN_CNTNG_PRTN_PRFL_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
428: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
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