APPS.PER_CAGR_UTILITY_PKG dependencies on HR_NAVIGATION_NODES

Line 280: from hr_navigation_nodes n, hr_navigation_node_usages nu

276: -- (as taskflow doesn't support additional form parameters).
277: --
278: CURSOR csr_nodes IS
279: select n.name
280: from hr_navigation_nodes n, hr_navigation_node_usages nu
281: where n.NAV_NODE_ID = nu.NAV_NODE_ID
282: and nu.NAV_NODE_USAGE_ID = p_nav_node_usage_id;
283:
284: --

Line 286: l_name hr_navigation_nodes.name%TYPE;

282: and nu.NAV_NODE_USAGE_ID = p_nav_node_usage_id;
283:
284: --
285: l_proc VARCHAR2(72) := g_pkg||'set_mode_from_node_name';
286: l_name hr_navigation_nodes.name%TYPE;
287: l_return VARCHAR2(20);
288: --
289: BEGIN
290: --