DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_HRS_WKD_IN_PERD_RT_F

Line 372: (rt_hrs_wkd_flag = 'Y' and exists (select '1' from BEN_HRS_WKD_IN_PERD_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id

368:
369: (rt_asnt_set_flag = 'Y' and exists (select '1' from BEN_ASNT_SET_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
370: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
371:
372: (rt_hrs_wkd_flag = 'Y' and exists (select '1' from BEN_HRS_WKD_IN_PERD_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
373: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
374:
375: (rt_comp_lvl_flag = 'Y' and exists (select '1' from BEN_COMP_LVL_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
376: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or