APPS.ENG_ECO_REVISION_UTIL dependencies on ENG_CHANGE_TYPE_PROCESSES

Line 48: l_process_name eng_change_type_processes.process_name%TYPE;

44: )
45: RETURN NUMBER
46: IS
47: l_id NUMBER :=1;
48: l_process_name eng_change_type_processes.process_name%TYPE;
49: BEGIN
50: SELECT process_name into l_process_name
51: FROM eng_change_type_processes
52: WHERE change_order_type_id = p_change_order_type_id --;

Line 51: FROM eng_change_type_processes

47: l_id NUMBER :=1;
48: l_process_name eng_change_type_processes.process_name%TYPE;
49: BEGIN
50: SELECT process_name into l_process_name
51: FROM eng_change_type_processes
52: WHERE change_order_type_id = p_change_order_type_id --;
53: -- Bug 3665542: Added additional where clause to fetch process name
54: AND ((p_priority_code is NOT NULL
55: AND eng_change_priority_code = p_priority_code