APPS.HR_KI_HNM_LOAD_API dependencies on HR_KI_USER_INTERFACES

Line 95: from HR_KI_USER_INTERFACES

91: where upper(HIERARCHY_KEY) = upper(X_HIERARCHY_KEY);
92:
93: CURSOR C_VAL_UI IS
94: select USER_INTERFACE_ID
95: from HR_KI_USER_INTERFACES
96: where upper(USER_INTERFACE_KEY) = upper(X_USER_INTERFACE_KEY);
97: begin
98:
99: if X_TOPIC_KEY is not null then

Line 163: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_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
167:

Line 184: hr_ki_user_interfaces ui

180: union
181: select nm.hierarchy_node_map_id
182: from hr_ki_hierarchy_node_maps nm,
183: hr_ki_topics top,
184: hr_ki_user_interfaces ui
185: where nm.topic_id = top.topic_id
186: and nm.user_interface_id = ui.user_interface_id
187: and top.topic_key = x_topic_key
188: and ui.user_interface_key =x_user_interface_key

Line 193: hr_ki_user_interfaces ui,

189:
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