DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_JOB_RT_F

Line 445: (rt_job_flag = 'Y' and exists (select '1' from BEN_JOB_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id

441:
442: (rt_comptncy_flag = 'Y' and exists (select '1' from BEN_COMPTNCY_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
443: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
444:
445: (rt_job_flag = 'Y' and exists (select '1' from BEN_JOB_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
446: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or
447:
448: (rt_qual_titl_flag = 'Y' and exists (select '1' from BEN_QUAL_TITL_RT_F where VRBL_RT_PRFL_ID = p_vrbl_rt_prfl_id
449: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)) or