DBA Data[Home] [Help]

APPS.AHL_AMP_WORKBENCH_PVT dependencies on CRP_CAL_SHIFT_DELTA

Line 98: FROM CRP_CAL_SHIFT_DELTA delta1

94: --AND TRUNC(cal.calendar_date) >= TRUNC(sysdate)
95: AND ((cal.seq_num IS NOT NULL
96: AND NOT EXISTS
97: (SELECT 1
98: FROM CRP_CAL_SHIFT_DELTA delta1
99: WHERE delta1.calendar_code = shifts.calendar_code
100: AND delta1.exception_set_id = param.calendar_exception_set_id
101: AND delta1.delta_code = 1
102: AND delta1.calendar_date = cal.calendar_date

Line 108: FROM CRP_CAL_SHIFT_DELTA delta1

104: ))
105: OR (cal.seq_num IS NULL
106: AND EXISTS
107: (SELECT 1
108: FROM CRP_CAL_SHIFT_DELTA delta1
109: WHERE delta1.calendar_code = shifts.calendar_code
110: AND delta1.exception_set_id = param.calendar_exception_set_id
111: AND delta1.delta_code = 2
112: AND delta1.calendar_date = cal.calendar_date