APPS.JTF_NOTES_MERGE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

  IS SELECT 	merge_reason_code
     FROM   	hz_merge_batch
     WHERE  	batch_id = p_batch_id;

Line: 71

    UPDATE jtf_notes_b
    SET	source_object_id  = p_to_fk_id
    ,   last_update_date  = hz_utility_pub.last_update_date
    ,   last_updated_by   = hz_utility_pub.user_id
    ,   last_update_login = hz_utility_pub.last_update_login
	WHERE source_object_code IN (SELECT ojt.object_code
                                 FROM jtf_objects_b     ojt
                                 ,    jtf_object_usages oue
                                 WHERE ojt.object_code = oue.object_code
                                 AND oue.object_user_code = 'NOTES'
                                 AND ojt.from_table ='HZ_PARTIES'
                                 )
	AND source_object_id = p_from_fk_id;

Line: 89

    UPDATE jtf_notes_b
    SET source_object_id  = p_to_fk_id
    ,   last_update_date  = hz_utility_pub.last_update_date
    ,   last_updated_by   = hz_utility_pub.user_id
    ,	last_update_login = hz_utility_pub.last_update_login
	WHERE source_object_code IN (SELECT ojt.object_code
                                 FROM jtf_objects_b     ojt
                                 ,    jtf_object_usages oue
                                 WHERE ojt.object_code = oue.object_code
                                 AND oue.object_user_code = 'NOTES'
                                 AND ojt.from_table ='HZ_PARTY_SITES'
                                 )
	AND source_object_id  = p_from_fk_id;

Line: 135

  IS SELECT merge_reason_code
     FROM   hz_merge_batch
     WHERE  batch_id = p_batch_id;

Line: 187

    UPDATE jtf_note_contexts
    SET	note_context_type_id   = p_to_fk_id
    ,   last_update_date  = hz_utility_pub.last_update_date
    ,   last_updated_by   = hz_utility_pub.user_id
    ,   last_update_login = hz_utility_pub.last_update_login
  	WHERE note_context_type IN (SELECT ojt.object_code
                                FROM jtf_objects_b ojt
                                ,    jtf_object_usages oue
                                WHERE ojt.object_code = oue.object_code
                                AND   oue.object_user_code = 'NOTES'
                                AND   ojt.from_table ='HZ_PARTIES'
                                )
    AND note_context_type_id = p_from_fk_id;

Line: 205

    UPDATE jtf_note_contexts
    SET	note_context_type_id   = p_to_fk_id
    ,   last_update_date  = hz_utility_pub.last_update_date
    ,   last_updated_by   = hz_utility_pub.user_id
    ,   last_update_login = hz_utility_pub.last_update_login
  	WHERE note_context_type IN (SELECT ojt.object_code
                                FROM jtf_objects_b ojt
                                ,    jtf_object_usages oue
                                WHERE ojt.object_code = oue.object_code
                                AND   oue.object_user_code = 'NOTES'
                                AND   ojt.from_table ='HZ_PARTY_SITES'
                                )
    AND note_context_type_id = p_from_fk_id;