APPS.HR_KI_HNM_LOAD_API dependencies on HR_KI_TOPICS

Line 85: from HR_KI_TOPICS

81: l_proc VARCHAR2(35) := 'HR_KI_HNM_LOAD_API.VALIDATE_KEYS';
82:
83: CURSOR C_VAL_TPC IS
84: select topic_id
85: from HR_KI_TOPICS
86: where upper(topic_key) = upper(X_TOPIC_KEY);
87:
88: CURSOR C_VAL_HI IS
89: select HIERARCHY_ID

Line 161: l_topic_id HR_KI_TOPICS.topic_id%TYPE;

157: l_last_update_login HR_KI_HIERARCHY_NODE_MAPS.last_update_login%TYPE := 0;
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

Line 172: hr_ki_topics top

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
176: top.topic_key = x_topic_key

Line 183: hr_ki_topics top,

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