APPS.HXT_GEN_AAI dependencies on HXT_SHIFT_DIFF_POLICIES
Line 110: FROM hxt_shift_diff_policies sdp
106:
107: /* Check whether the Shift Differentail Policy and Assignment are compatible */
108: CURSOR chk_shift_diff_policy IS
109: SELECT 'compatible' 110: FROM hxt_shift_diff_policies sdp 111: WHERE p_effective_start_date between sdp.date_from
112: and nvl(sdp.date_to
113: ,p_effective_start_date)
114: AND EXISTS