APPS.AMW_PARTY_MERGE_PKG SQL Statements

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

Line: 35

        UPDATE amw_assessments_b
        SET assessment_owner_id = p_to_fk_id
        WHERE assessment_owner_id = p_from_fk_id;

Line: 41

        UPDATE amw_constraints_b
        SET entered_by_id = p_to_fk_id
        WHERE entered_by_id = p_from_fk_id;

Line: 47

        UPDATE amw_certification_b
        SET certification_owner_id = p_to_fk_id
        WHERE certification_owner_id = p_from_fk_id;

Line: 53

        UPDATE amw_violations
        SET requested_by_id = p_to_fk_id
        WHERE requested_by_id = p_from_fk_id;

Line: 59

        UPDATE amw_ap_executions
        SET executed_by = p_to_fk_id
        WHERE executed_by = p_from_fk_id;