[Home] [Help]
191: END IF;
192:
193: SELECT process_name
194: INTO l_process_name
195: FROM eng_change_type_processes
196: WHERE change_order_type_id = p_change_order_type_id
197: AND ( p_priority_code is NOT NULL
198: AND eng_change_priority_code = p_priority_code
199: AND organization_id = p_organization_id)