APPS.HR_KI_TIS_LOAD_API dependencies on HR_KI_INTEGRATIONS

Line 241: from HR_KI_INTEGRATIONS

237: where upper(topic_key) = upper(X_TOPIC_KEY);
238: --
239: CURSOR C_VAL_INT IS
240: select integration_id
241: from HR_KI_INTEGRATIONS
242: where upper(integration_key) = upper(X_INTEGRATION_KEY);
243: --
244: begin
245: open C_VAL_TPC;

Line 306: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;

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: --
310: CURSOR C_APPL IS

Line 315: hr_ki_integrations int

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
319: and int.integration_key = X_INTEGRATION_KEY;