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 896: FROM eng_change_statuses ecs, eng_revised_items eri

892:
893: CURSOR c_get_rev_item_status_type
894: IS
895: SELECT ecs.status_type
896: FROM eng_change_statuses ecs, eng_revised_items eri
897: WHERE ecs.status_code = eri.status_code
898: AND eri.revised_item_sequence_id = p_revised_item_seq_id;
899:
900: CURSOR c_plm_or_erp