DBA Data[Home] [Help]

APPS.HR_WORKFLOW_INSTALL_PKG dependencies on HR_NAVIGATION_NODE_USAGES

Line 59: FROM hr_navigation_node_usages NNU,

55: nu.form_name AS to_form_name,
56: nn.name AS to_node_name,
57: to_char(p.sequence) AS sequence,
58: ptl.override_label AS Button_label
59: FROM hr_navigation_node_usages NNU,
60: hr_navigation_node_usages NNU2,
61: hr_workflows W,
62: hr_navigation_units NU,
63: hr_navigation_nodes NN,

Line 60: hr_navigation_node_usages NNU2,

56: nn.name AS to_node_name,
57: to_char(p.sequence) AS sequence,
58: ptl.override_label AS Button_label
59: FROM hr_navigation_node_usages NNU,
60: hr_navigation_node_usages NNU2,
61: hr_workflows W,
62: hr_navigation_units NU,
63: hr_navigation_nodes NN,
64: hr_navigation_units NU2,

Line 373: from hr_navigation_node_usages

369: end get_nav_node_id;
370: procedure get_node_usage_id is
371: cursor id is
372: select nav_node_usage_id
373: from hr_navigation_node_usages
374: where nav_node_id = current_nav_node_id
375: and workflow_id = current_workflow_id;
376: begin
377: open id;

Line 469: insert into hr_navigation_node_usages (

465: end new_nav_node;
466: procedure new_nav_node_usage (
467: p_top_node varchar2) is
468: begin
469: insert into hr_navigation_node_usages (
470: nav_node_usage_id,
471: workflow_id,
472: nav_node_id,
473: top_node)

Line 475: hr_navigation_node_usages_s.nextval,

471: workflow_id,
472: nav_node_id,
473: top_node)
474: values (
475: hr_navigation_node_usages_s.nextval,
476: current_workflow_id,
477: current_nav_node_id,
478: p_top_node);
479: get_node_usage_id;