364: begin
365:
366: select NAV_NODE_ID
367: into X_FROM_NAV_NODE_ID
368: from HR_NAVIGATION_NODES
369: where NAME = X_NODE_NAME_FROM;
370:
371: select NAV_NODE_USAGE_ID
372: into X_FROM_NAV_NODE_USAGE_ID
386: begin
387:
388: select NAV_NODE_ID
389: into X_TO_NAV_NODE_ID
390: from HR_NAVIGATION_NODES
391: where NAME = X_NODE_NAME_TO;
392:
393: select NAV_NODE_USAGE_ID
394: into X_TO_NAV_NODE_USAGE_ID
476: begin
477:
478: select NAV_NODE_ID
479: into X_FROM_NAV_NODE_ID
480: from HR_NAVIGATION_NODES
481: where NAME = X_NODE_NAME_FROM;
482:
483: select NAV_NODE_USAGE_ID
484: into X_FROM_NAV_NODE_USAGE_ID
498: begin
499:
500: select NAV_NODE_ID
501: into X_TO_NAV_NODE_ID
502: from HR_NAVIGATION_NODES
503: where NAME = X_NODE_NAME_TO;
504:
505: select NAV_NODE_USAGE_ID
506: into X_TO_NAV_NODE_USAGE_ID