DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_SCHEDD_HRS_RT_F

Line 387: (rt_schedd_hrs_flag = 'Y' and exists (select '1' from BEN_SCHEDD_HRS_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id

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
386:
387: (rt_schedd_hrs_flag = 'Y' and exists (select '1' from BEN_SCHEDD_HRS_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
388: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
389:
390: (rt_py_bss_flag = 'Y' and exists (select '1' from BEN_PY_BSS_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
391: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or