DBA Data[Home] [Help]

APPS.AMW_VIOLATION_PUB dependencies on AMW_CONSTRAINTS_B

Line 187: FROM amw_constraints_b

183:
184: -- find all valid preventive constraints
185: CURSOR c_all_valid_constraints IS
186: SELECT constraint_rev_id, type_code
187: FROM amw_constraints_b
188: WHERE start_date <= sysdate AND (end_date IS NULL OR end_date >= sysdate)
189: AND objective_code = 'PR';
190:
191: