APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_TYPE_REASONS
Line 233: FROM ENG_CHANGE_TYPE_REASONS
229: l_reason_code VARCHAR2(10);
230:
231: CURSOR REASONS IS
232: SELECT * 233: FROM ENG_CHANGE_TYPE_REASONS 234: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
235: BEGIN
236: FOR cl in REASONS
237: LOOP
Line 238: INSERT INTO ENG_CHANGE_TYPE_REASONS
234: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
235: BEGIN
236: FOR cl in REASONS
237: LOOP 238: INSERT INTO ENG_CHANGE_TYPE_REASONS 239: (CHANGE_TYPE_ID,
240: REASON_CODE,
241: CREATION_DATE,
242: CREATED_BY,