APPS.HR_KI_TIS_LOAD_API dependencies on HR_KI_TOPICS

Line 236: from HR_KI_TOPICS

232: l_proc VARCHAR2(35) := 'HR_KI_TIS_LOAD_API.VALIDATE_KEYS';
233: --
234: CURSOR C_VAL_TPC IS
235: select topic_id
236: from HR_KI_TOPICS
237: where upper(topic_key) = upper(X_TOPIC_KEY);
238: --
239: CURSOR C_VAL_INT IS
240: select integration_id

Line 305: l_topic_id HR_KI_TOPICS.topic_id%TYPE;

301: l_last_updated_by HR_KI_TOPIC_INTEGRATIONS.last_updated_by%TYPE := 0;
302: l_last_update_login HR_KI_TOPIC_INTEGRATIONS.last_update_login%TYPE := 0;
303: l_topic_integrations_id HR_KI_TOPIC_INTEGRATIONS.topic_integrations_id%TYPE;
304: l_object_version_number HR_KI_TOPIC_INTEGRATIONS.object_version_number%TYPE;
305: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
306: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
307: db_luby number; -- entity owner in db
308: db_ludate date; -- entity update date in db
309: --

Line 314: hr_ki_topics top,

310: CURSOR C_APPL IS
311: select tpi.topic_integrations_id,
312: nvl(tpi.object_version_number,1)
313: from hr_ki_topic_integrations tpi,
314: hr_ki_topics top,
315: hr_ki_integrations int
316: where tpi.topic_id = top.topic_id
317: and tpi.integration_id = int.integration_id
318: and top.topic_key = X_TOPIC_KEY