APPS.ENGPKIMP dependencies on ENG_CHANGE_STATUSES

Line 211: eng_change_statuses s

207: -- check if there are any pending mandatory tasks in the ECO
208: SELECT count(1)
209: INTO l_mandatory_task_count
210: FROM eng_change_lines l,
211: eng_change_statuses s
212: WHERE l.change_id = p_change_id
213: AND s.status_code = l.status_code
214: AND l.complete_before_status_code IS NOT NULL
215: AND s.status_type NOT IN (5, 6, 11)

Line 824: FROM eng_change_statuses ecs, eng_revised_items eri

820:
821: CURSOR c_get_rev_item_status_type
822: IS
823: SELECT ecs.status_type
824: FROM eng_change_statuses ecs, eng_revised_items eri
825: WHERE ecs.status_code = eri.status_code
826: AND eri.revised_item_sequence_id = p_revised_item_seq_id;
827:
828: CURSOR c_plm_or_erp