APPS.OKE_APPROVAL_PATHS_PKG dependencies on OKE_APPROVAL_STEPS

Line 306: DELETE FROM OKE_APPROVAL_STEPS

302: --
303: -- If CUSTOM_MODE is FORCE, tramp all approval steps
304: --
305: IF ( X_CUSTOM_MODE = 'FORCE' ) THEN
306: DELETE FROM OKE_APPROVAL_STEPS
307: WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID;
308: END IF;
309:
310: END LOAD_ROW;

Line 442: FROM oke_approval_steps

438: ) RETURN VARCHAR2 IS
439:
440: CURSOR a IS
441: SELECT approval_sequence || ',' || approver_role_id || ';' approval_step
442: FROM oke_approval_steps
443: WHERE approval_path_id = ApprovalPath
444: ORDER BY approval_sequence ASC;
445: arec a%rowtype;
446: