APPS.PA_MERGE_PKG SQL Statements

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

Line: 46

    UPDATE pa_control_items
    SET owner_id = p_to_fk_id
    WHERE owner_id = p_from_fk_id;

Line: 70

    UPDATE pa_control_items
    SET last_modified_by_id = p_to_fk_id
    WHERE last_modified_by_id = p_from_fk_id;

Line: 94

    UPDATE pa_control_items
    SET closed_by_id = p_to_fk_id
    WHERE closed_by_id = p_from_fk_id;

Line: 118

    UPDATE pa_ci_actions
    SET assigned_to = p_to_fk_id
    WHERE assigned_to = p_from_fk_id;

Line: 143

    UPDATE pa_ci_impacts
    SET implemented_by = p_to_fk_id
    WHERE implemented_by = p_from_fk_id;

Line: 170

      SELECT 1
      INTO l_dummy
      FROM fnd_grants g, fnd_objects o
      WHERE o.application_id = 275
        AND g.object_id = o.object_id
        AND g.grantee_type = 'USER'
        AND g.grantee_key = 'HZ_PARTY:'||p_from_fk_id
        AND ROWNUM = 1;

Line: 187

        UPDATE pa_project_parties
        SET resource_source_id = p_to_fk_id
        WHERE resource_source_id = p_from_fk_id
          AND resource_type_id = 112;

Line: 198

PROCEDURE update_project_parties_res_id(
  p_from_resource_id IN NUMBER,
  p_to_resource_id IN NUMBER,
  x_return_status OUT NOCOPY VARCHAR2)
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 207

    UPDATE pa_project_parties
    SET resource_id = p_to_resource_id
    WHERE resource_id = p_from_resource_id;

Line: 211

END update_project_parties_res_id;