APPS.UMX_PARTY_MERGE SQL Statements

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

Line: 17

CURSOR GET_STATUS IS SELECT STATUS_CODE FROM UMX_REG_REQUESTS
WHERE REQUESTED_FOR_PARTY_ID = p_from_fk_id
and status_code = 'PENDING';

Line: 50

             update umx_reg_requests set requested_for_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 requested_for_party_id = p_From_FK_id;