DBA Data[Home] [Help]

APPS.OKE_PARTY_MERGE_PKG SQL Statements

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

Line: 33

    UPDATE OKE_POOL_PARTIES
    SET    party_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  party_id = p_from_fk_id;
Line: 78

    UPDATE OKE_K_FUNDING_SOURCES
    SET    k_party_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  k_party_id = p_from_fk_id;
Line: 123

    UPDATE OKE_K_FUNDING_SOURCES_H
    SET    k_party_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  k_party_id = p_from_fk_id;