[Home] [Help]
460: IF l_classification IS NULL THEN
461: BEGIN
462: SELECT work_type_id
463: INTO l_classification
464: FROM amw_work_types_b
465: WHERE work_type_code = 'AMW_UNDEF'
466: AND object_id = (SELECT object_id
467: FROM fnd_objects
468: WHERE obj_name = 'AMW_CONSTRAINT');