APPS.ENG_CANCEL_ECO dependencies on ENG_ENGINEERING_CHANGES

Line 33: FROM eng_engineering_changes

29: and status_type not in (5,6);
30:
31: CURSOR update_att_status is
32: SELECT change_id, change_mgmt_type_code
33: FROM eng_engineering_changes
34: WHERE organization_id = org_id
35: and change_notice = change_order;
36:
37: -- Changes for Bug 3668603

Line 144: UPDATE ENG_ENGINEERING_CHANGES

140:
141: /*
142: ** set cancel date and comments on ECO
143: stmt_num := 5;
144: UPDATE ENG_ENGINEERING_CHANGES
145: SET CANCELLATION_DATE = SYSDATE,
146: STATUS_TYPE = 5,
147: CANCELLATION_COMMENTS = comment,
148: LAST_UPDATED_BY = user_id,