APPS.HR_KI_HNM_LOAD_API dependencies on HR_KI_HIERARCHIES

Line 90: from HR_KI_HIERARCHIES

86: where upper(topic_key) = upper(X_TOPIC_KEY);
87:
88: CURSOR C_VAL_HI IS
89: select HIERARCHY_ID
90: from HR_KI_HIERARCHIES
91: where upper(HIERARCHY_KEY) = upper(X_HIERARCHY_KEY);
92:
93: CURSOR C_VAL_UI IS
94: select USER_INTERFACE_ID

Line 162: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;

158: l_hierarchy_node_map_id HR_KI_HIERARCHY_NODE_MAPS.hierarchy_node_map_id%TYPE;
159:
160:
161: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
162: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;
163: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;
164:
165: db_luby number; -- entity owner in db
166: db_ludate date; -- entity update date in db

Line 171: hr_ki_hierarchies h,

167:
168: CURSOR C_APPL IS
169: select nm.hierarchy_node_map_id
170: from hr_ki_hierarchy_node_maps nm,
171: hr_ki_hierarchies h,
172: hr_ki_topics top
173: where nm.hierarchy_id = h.hierarchy_id
174: and nm.topic_id = top.topic_id
175: and

Line 194: hr_ki_hierarchies hi

190: union
191: select nm.hierarchy_node_map_id
192: from hr_ki_hierarchy_node_maps nm,
193: hr_ki_user_interfaces ui,
194: hr_ki_hierarchies hi
195: where nm.hierarchy_id = hi.hierarchy_id
196: and nm.user_interface_id = ui.user_interface_id
197: and ui.user_interface_key = x_user_interface_key
198: and hi.hierarchy_key = x_hierarchy_key;