APPS.AMW_LOAD_SOD_DATA dependencies on AMW_LOOKUPS

Line 90: FROM amw_lookups

86: FROM amw_constraint_interface
87: WHERE batch_id = p_batch_id
88: AND NOT EXISTS
89: ( SELECT 'Y'
90: FROM amw_lookups
91: WHERE lookup_code = cst_type_code
92: AND lookup_type='AMW_CONSTRAINT_TYPE'
93: AND enabled_flag ='Y'
94: AND (end_date_active > SYSDATE OR end_date_active IS NULL)