APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_TYPE_REASONS
Line 270: FROM ENG_CHANGE_TYPE_REASONS
266: l_reason_code VARCHAR2(10);
267:
268: CURSOR REASONS IS
269: SELECT * 270: FROM ENG_CHANGE_TYPE_REASONS 271: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
272: BEGIN
273: FOR cl in REASONS
274: LOOP
Line 275: INSERT INTO ENG_CHANGE_TYPE_REASONS
271: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
272: BEGIN
273: FOR cl in REASONS
274: LOOP 275: INSERT INTO ENG_CHANGE_TYPE_REASONS 276: (CHANGE_TYPE_ID,
277: REASON_CODE,
278: CREATION_DATE,
279: CREATED_BY,