APPS.JTF_IH_IMPORT dependencies on JTF_IH_ACTIVITIES_STG_LOG

Line 694: (SELECT activity_id FROM jtf_ih_activities_stg_log

690: (SELECT interaction_id FROM jtf_ih_interactions_stg_log
691: WHERE session_no = nSessionNo);
692:
693: SELECT COUNT(*) INTO nErr_ActivCnt FROM
694: (SELECT activity_id FROM jtf_ih_activities_stg_log
695: WHERE session_no = nSessionNo);
696:
697: SELECT COUNT(*) INTO nErr_MediaCnt FROM
698: (SELECT media_id FROM jtf_ih_media_items_stg_log

Line 963: INSERT INTO jtf_ih_activities_stg_log(

959: PROCEDURE Insert_Activity_Log( nActivityID NUMBER, nInteractionID NUMBER, sComments VARCHAR2, nSessionNo IN OUT NOCOPY NUMBER) AS
960: l_Comments VARCHAR(2000);
961: BEGIN
962: l_Comments := sComments;
963: INSERT INTO jtf_ih_activities_stg_log(
964: activity_id,
965: object_version_number,
966: creation_date,
967: created_by,