311: where NAME = X_NODE_NAME_FROM;
312:
313: select NAV_NODE_USAGE_ID
314: into X_FROM_NAV_NODE_USAGE_ID
315: from HR_NAVIGATION_NODE_USAGES
316: where WORKFLOW_ID = X_WORKFLOW_ID
317: and NAV_NODE_ID = X_FROM_NAV_NODE_ID;
318:
319: exception
333: where NAME = X_NODE_NAME_TO;
334:
335: select NAV_NODE_USAGE_ID
336: into X_TO_NAV_NODE_USAGE_ID
337: from HR_NAVIGATION_NODE_USAGES
338: where WORKFLOW_ID = X_WORKFLOW_ID
339: and NAV_NODE_ID = X_TO_NAV_NODE_ID;
340:
341: exception
423: where NAME = X_NODE_NAME_FROM;
424:
425: select NAV_NODE_USAGE_ID
426: into X_FROM_NAV_NODE_USAGE_ID
427: from HR_NAVIGATION_NODE_USAGES
428: where WORKFLOW_ID = X_WORKFLOW_ID
429: and NAV_NODE_ID = X_FROM_NAV_NODE_ID;
430:
431: exception
445: where NAME = X_NODE_NAME_TO;
446:
447: select NAV_NODE_USAGE_ID
448: into X_TO_NAV_NODE_USAGE_ID
449: from HR_NAVIGATION_NODE_USAGES
450: where WORKFLOW_ID = X_WORKFLOW_ID
451: and NAV_NODE_ID = X_TO_NAV_NODE_ID;
452:
453: exception