APPS.FTE_PARTY_MERGE SQL Statements

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

Line: 27

  SELECT merge_reason_code
  INTO   l_merge_reason_code
  FROM   hz_merge_batch
  WHERE  batch_id  = p_batch_id;

Line: 59

	    -- obtain lock on records to be updated.
    SELECT facility_id
    INTO   l_facility_id
    FROM   fte_location_parameters
    WHERE  facility_contact_id = p_from_fk_id
    FOR UPDATE NOWAIT;

Line: 67

      UPDATE fte_location_parameters
      SET    facility_contact_id = p_to_fk_id,
             last_update_date = hz_utility_v2pub.last_update_date,
             last_updated_by = hz_utility_v2pub.user_id,
             last_update_login = hz_utility_v2pub.last_update_login,
             request_id =  hz_utility_v2pub.request_id,
             program_application_id = hz_utility_v2pub.program_application_id,
             program_id = hz_utility_v2pub.program_id,
             program_update_date = sysdate
      WHERE  facility_contact_id = p_from_fk_id;