[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT creation_date,
NEW_operating_unit_id,
NEW_relationship_type_code,
NEW_active_start_date,
NEW_active_end_date,
NEW_context,
NEW_attribute1 ,
NEW_attribute2,
NEW_attribute3,
NEW_attribute4,
NEW_attribute5,
NEW_attribute6,
NEW_attribute7,
NEW_attribute8,
NEW_attribute9,
NEW_attribute10,
NEW_attribute11,
NEW_attribute12,
NEW_attribute13,
NEW_attribute14,
NEW_attribute15
FROM csi_i_org_assignments_h
WHERE instance_ou_id = p_ou_id
ORDER BY creation_date;
SELECT creation_date,
NEW_operating_unit_id,
NEW_relationship_type_code,
NEW_active_start_date,
NEW_active_end_date,
NEW_context,
NEW_attribute1 ,
NEW_attribute2,
NEW_attribute3,
NEW_attribute4,
NEW_attribute5,
NEW_attribute6,
NEW_attribute7,
NEW_attribute8,
NEW_attribute9,
NEW_attribute10,
NEW_attribute11,
NEW_attribute12,
NEW_attribute13,
NEW_attribute14,
NEW_attribute15
FROM csi_i_org_assignments_h
WHERE instance_ou_history_id = p_ou_hist_id
AND full_dump_flag = 'Y';
SELECT MAX(instance_ou_history_id)
FROM csi_i_org_assignments_h
WHERE creation_date <= p_time
AND instance_ou_id = p_inst_ou_id
AND full_dump_flag = 'Y';
SELECT
OLD_OPERATING_UNIT_ID,
NEW_OPERATING_UNIT_ID ,
OLD_RELATIONSHIP_TYPE_CODE ,
NEW_RELATIONSHIP_TYPE_CODE ,
OLD_ACTIVE_START_DATE,
NEW_ACTIVE_START_DATE,
OLD_ACTIVE_END_DATE ,
NEW_ACTIVE_END_DATE ,
OLD_CONTEXT ,
NEW_CONTEXT ,
OLD_ATTRIBUTE1 ,
NEW_ATTRIBUTE1 ,
OLD_ATTRIBUTE2 ,
NEW_ATTRIBUTE2 ,
OLD_ATTRIBUTE3 ,
NEW_ATTRIBUTE3 ,
OLD_ATTRIBUTE4 ,
NEW_ATTRIBUTE4 ,
OLD_ATTRIBUTE5 ,
NEW_ATTRIBUTE5 ,
OLD_ATTRIBUTE6 ,
NEW_ATTRIBUTE6 ,
OLD_ATTRIBUTE7 ,
NEW_ATTRIBUTE7 ,
OLD_ATTRIBUTE8 ,
NEW_ATTRIBUTE8 ,
OLD_ATTRIBUTE9 ,
NEW_ATTRIBUTE9 ,
OLD_ATTRIBUTE10 ,
NEW_ATTRIBUTE10 ,
OLD_ATTRIBUTE11 ,
NEW_ATTRIBUTE11 ,
OLD_ATTRIBUTE12 ,
NEW_ATTRIBUTE12 ,
OLD_ATTRIBUTE13 ,
NEW_ATTRIBUTE13 ,
OLD_ATTRIBUTE14 ,
NEW_ATTRIBUTE14 ,
OLD_ATTRIBUTE15 ,
NEW_ATTRIBUTE15
FROM CSI_I_ORG_ASSIGNMENTS_H
WHERE creation_date <= p_time
AND creation_date >= p_nearest_full_dump
AND instance_ou_id = p_inst_ou_id
ORDER BY creation_date;
l_ou_tbl.DELETE(i);
x_ou_tbl.DELETE;
SELECT name
INTO p_org_units_header_tbl(tab_row).operating_unit_name
FROM hr_operating_units
WHERE organization_id = p_org_units_header_tbl(tab_row).operating_unit_id;
SELECT meaning
INTO p_org_units_header_tbl(tab_row).relationship_type_name
FROM csi_lookups
WHERE lookup_code = p_org_units_header_tbl(tab_row).relationship_type_code
AND lookup_type = l_rltn_lookup_type;
'INSERT')) THEN
RAISE FND_API.G_EXC_ERROR;
SELECT instance_ou_id,
object_version_number
INTO p_org_unit_rec.instance_ou_id,
p_org_unit_rec.object_version_number
FROM csi_i_org_assignments
WHERE instance_id = p_org_unit_rec.instance_id
-- AND operating_unit_id = p_org_unit_rec.operating_unit_id -- Fix for Bug 3918188
AND relationship_type_code = p_org_unit_rec.relationship_type_code
AND active_end_date < SYSDATE
AND ROWNUM = 1 ;
csi_organization_unit_pvt.update_organization_unit
( p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_org_unit_rec => p_org_unit_rec
,p_txn_rec => p_txn_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_lookup_tbl => l_ou_lookup_tbl
,p_ou_count_rec => l_ou_count_rec
,p_ou_id_tbl => l_ou_id_tbl
);
csi_gen_utility_pvt.put_line( ' Failed Pvt:update_organization_unit..');
CSI_I_ORG_ASSIGNMENTS_PKG.Insert_Row(
l_instance_ou_id
,p_org_unit_rec.instance_id
,p_org_unit_rec.operating_unit_id
,p_org_unit_rec.relationship_type_code
,p_org_unit_rec.active_start_date
,p_org_unit_rec.active_end_date
,p_org_unit_rec.context
,p_org_unit_rec.attribute1
,p_org_unit_rec.attribute2
,p_org_unit_rec.attribute3
,p_org_unit_rec.attribute4
,p_org_unit_rec.attribute5
,p_org_unit_rec.attribute6
,p_org_unit_rec.attribute7
,p_org_unit_rec.attribute8
,p_org_unit_rec.attribute9
,p_org_unit_rec.attribute10
,p_org_unit_rec.attribute11
,p_org_unit_rec.attribute12
,p_org_unit_rec.attribute13
,p_org_unit_rec.attribute14
,p_org_unit_rec.attribute15
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,1
);
CSI_I_ORG_ASSIGNMENTS_H_PKG.Insert_Row(
l_csi_i_org_assign_h_id
,l_instance_ou_id
,p_txn_rec.TRANSACTION_ID
,NULL
,p_org_unit_rec.OPERATING_UNIT_ID
,NULL
,p_org_unit_rec.RELATIONSHIP_TYPE_CODE
,NULL
,NVL(p_org_unit_rec.ACTIVE_START_DATE, SYSDATE)
,NULL
,p_org_unit_rec.ACTIVE_END_DATE
,NULL
,p_org_unit_rec.context
,NULL
,p_org_unit_rec.ATTRIBUTE1
,NULL
,p_org_unit_rec.ATTRIBUTE2
,NULL
,p_org_unit_rec.ATTRIBUTE3
,NULL
,p_org_unit_rec.ATTRIBUTE4
,NULL
,p_org_unit_rec.ATTRIBUTE5
,NULL
,p_org_unit_rec.ATTRIBUTE6
,NULL
,p_org_unit_rec.ATTRIBUTE7
,NULL
,p_org_unit_rec.ATTRIBUTE8
,NULL
,p_org_unit_rec.ATTRIBUTE9
,NULL
,p_org_unit_rec.ATTRIBUTE10
,NULL
,p_org_unit_rec.ATTRIBUTE11
,NULL
,p_org_unit_rec.ATTRIBUTE12
,NULL
,p_org_unit_rec.ATTRIBUTE13
,NULL
,p_org_unit_rec.ATTRIBUTE14
,NULL
,p_org_unit_rec.ATTRIBUTE15
,l_dump_frequency_flag
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,1);
/* procedure name: update_organization_unit */
/* description : Updates an existing instance-org */
/* association */
/* */
/*-------------------------------------------------------*/
PROCEDURE update_organization_unit
(
p_api_version IN NUMBER
,p_commit IN VARCHAR2
,p_init_msg_list IN VARCHAR2
,p_validation_level IN NUMBER
,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl
,p_ou_count_rec IN OUT NOCOPY csi_organization_unit_pvt.ou_count_rec
,p_ou_id_tbl IN OUT NOCOPY csi_organization_unit_pvt.ou_id_tbl
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'update_organization_unit';
SELECT instance_ou_history_id
,instance_ou_id
,transaction_id
,old_operating_unit_id
,new_operating_unit_id
,old_relationship_type_code
,new_relationship_type_code
,old_active_start_date
,new_active_start_date
,old_active_end_date
,new_active_end_date
,old_context
,new_context
,old_attribute1
,new_attribute1
,old_attribute2
,new_attribute2
,old_attribute3
,new_attribute3
,old_attribute4
,new_attribute4
,old_attribute5
,new_attribute5
,old_attribute6
,new_attribute6
,old_attribute7
,new_attribute7
,old_attribute8
,new_attribute8
,old_attribute9
,new_attribute9
,old_attribute10
,new_attribute10
,old_attribute11
,new_attribute11
,old_attribute12
,new_attribute12
,old_attribute13
,new_attribute13
,old_attribute14
,new_attribute14
,old_attribute15
,new_attribute15
,full_dump_flag
,object_version_number
FROM csi_i_org_assignments_h
WHERE csi_i_org_assignments_h.instance_ou_history_id = p_org_hist_id
FOR UPDATE OF object_version_number ;
SAVEPOINT update_organization_unit;
csi_gen_utility_pvt.put_line( 'update_organization_unit');
'UPDATE'
)) THEN
-- Check if it is an expire operation
IF NOT(csi_org_unit_vld_pvt.Is_Expire_Op
(p_org_unit_rec)) THEN
RAISE FND_API.G_EXC_ERROR;
IF NOT(csi_org_unit_vld_pvt.Val_inst_id_for_update
(p_org_unit_rec.instance_id
,l_org_unit_rec.instance_id
)) THEN
RAISE FND_API.G_EXC_ERROR;
CSI_I_ORG_ASSIGNMENTS_PKG.Update_Row(
l_instance_ou_id
,p_org_unit_rec.instance_id
,p_org_unit_rec.operating_unit_id
,p_org_unit_rec.relationship_type_code
,p_org_unit_rec.active_start_date
,p_org_unit_rec.active_end_date
,p_org_unit_rec.context
,p_org_unit_rec.attribute1
,p_org_unit_rec.attribute2
,p_org_unit_rec.attribute3
,p_org_unit_rec.attribute4
,p_org_unit_rec.attribute5
,p_org_unit_rec.attribute6
,p_org_unit_rec.attribute7
,p_org_unit_rec.attribute8
,p_org_unit_rec.attribute9
,p_org_unit_rec.attribute10
,p_org_unit_rec.attribute11
,p_org_unit_rec.attribute12
,p_org_unit_rec.attribute13
,p_org_unit_rec.attribute14
,p_org_unit_rec.attribute15
,fnd_api.g_miss_num -- fnd_global.user_id
,fnd_api.g_miss_date
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,l_org_unit_rec.object_version_number
);
SELECT instance_ou_history_id
INTO l_org_hist_id
FROM csi_i_org_assignments_h h
WHERE h.transaction_id = p_txn_rec.transaction_id
AND h.instance_ou_id = p_org_unit_rec.instance_ou_id;
csi_i_org_assignments_h_pkg.update_row(
p_instance_ou_history_id => l_org_hist_id ,
p_instance_ou_id => fnd_api.g_miss_num ,
p_transaction_id => fnd_api.g_miss_num ,
p_old_operating_unit_id => fnd_api.g_miss_num ,
p_new_operating_unit_id => l_temp_org_unit_rec.operating_unit_id ,
p_old_relationship_type_code => fnd_api.g_miss_char ,
p_new_relationship_type_code => l_temp_org_unit_rec.relationship_type_code,
p_old_active_start_date => fnd_api.g_miss_date ,
p_new_active_start_date => l_temp_org_unit_rec.active_start_date ,
p_old_active_end_date => fnd_api.g_miss_date ,
p_new_active_end_date => l_temp_org_unit_rec.active_end_date ,
p_old_context => fnd_api.g_miss_char ,
p_new_context => l_temp_org_unit_rec.context ,
p_old_attribute1 => fnd_api.g_miss_char ,
p_new_attribute1 => l_temp_org_unit_rec.attribute1 ,
p_old_attribute2 => fnd_api.g_miss_char ,
p_new_attribute2 => l_temp_org_unit_rec.attribute2 ,
p_old_attribute3 => fnd_api.g_miss_char ,
p_new_attribute3 => l_temp_org_unit_rec.attribute3 ,
p_old_attribute4 => fnd_api.g_miss_char ,
p_new_attribute4 => l_temp_org_unit_rec.attribute4 ,
p_old_attribute5 => fnd_api.g_miss_char ,
p_new_attribute5 => l_temp_org_unit_rec.attribute5 ,
p_old_attribute6 => fnd_api.g_miss_char ,
p_new_attribute6 => l_temp_org_unit_rec.attribute6 ,
p_old_attribute7 => fnd_api.g_miss_char ,
p_new_attribute7 => l_temp_org_unit_rec.attribute7 ,
p_old_attribute8 => fnd_api.g_miss_char ,
p_new_attribute8 => l_temp_org_unit_rec.attribute8 ,
p_old_attribute9 => fnd_api.g_miss_char ,
p_new_attribute9 => l_temp_org_unit_rec.attribute9 ,
p_old_attribute10 => fnd_api.g_miss_char ,
p_new_attribute10 => l_temp_org_unit_rec.attribute10 ,
p_old_attribute11 => fnd_api.g_miss_char ,
p_new_attribute11 => l_temp_org_unit_rec.attribute11 ,
p_old_attribute12 => fnd_api.g_miss_char ,
p_new_attribute12 => l_temp_org_unit_rec.attribute12 ,
p_old_attribute13 => fnd_api.g_miss_char ,
p_new_attribute13 => l_temp_org_unit_rec.attribute13 ,
p_old_attribute14 => fnd_api.g_miss_char ,
p_new_attribute14 => l_temp_org_unit_rec.attribute14 ,
p_old_attribute15 => fnd_api.g_miss_char ,
p_new_attribute15 => l_temp_org_unit_rec.attribute15 ,
p_full_dump_flag => fnd_api.g_miss_char ,
p_created_by => fnd_api.g_miss_num, -- fnd_global.user_id ,
p_creation_date => fnd_api.g_miss_date ,
p_last_updated_by => fnd_global.user_id ,
p_last_update_date => sysdate ,
p_last_update_login => fnd_global.user_id ,
p_object_version_number => fnd_api.g_miss_num );
csi_i_org_assignments_h_pkg.update_row(
p_instance_ou_history_id => l_org_hist_id ,
p_instance_ou_id => fnd_api.g_miss_num ,
p_transaction_id => fnd_api.g_miss_num ,
p_old_operating_unit_id => l_org_hist_csr.old_operating_unit_id ,
p_new_operating_unit_id => l_org_hist_csr.new_operating_unit_id ,
p_old_relationship_type_code => l_org_hist_csr.old_relationship_type_code ,
p_new_relationship_type_code => l_org_hist_csr.new_relationship_type_code,
p_old_active_start_date => l_org_hist_csr.old_active_start_date ,
p_new_active_start_date => l_org_hist_csr.new_active_start_date ,
p_old_active_end_date => l_org_hist_csr.old_active_end_date ,
p_new_active_end_date => l_org_hist_csr.new_active_end_date ,
p_old_context => l_org_hist_csr.old_context ,
p_new_context => l_org_hist_csr.new_context ,
p_old_attribute1 => l_org_hist_csr.old_attribute1 ,
p_new_attribute1 => l_org_hist_csr.new_attribute1 ,
p_old_attribute2 => l_org_hist_csr.old_attribute2 ,
p_new_attribute2 => l_org_hist_csr.new_attribute2 ,
p_old_attribute3 => l_org_hist_csr.old_attribute3 ,
p_new_attribute3 => l_org_hist_csr.new_attribute3 ,
p_old_attribute4 => l_org_hist_csr.old_attribute4 ,
p_new_attribute4 => l_org_hist_csr.new_attribute4 ,
p_old_attribute5 => l_org_hist_csr.old_attribute5 ,
p_new_attribute5 => l_org_hist_csr.new_attribute5 ,
p_old_attribute6 => l_org_hist_csr.old_attribute6 ,
p_new_attribute6 => l_org_hist_csr.new_attribute6 ,
p_old_attribute7 => l_org_hist_csr.old_attribute7 ,
p_new_attribute7 => l_org_hist_csr.new_attribute7 ,
p_old_attribute8 => l_org_hist_csr.old_attribute8 ,
p_new_attribute8 => l_org_hist_csr.new_attribute8 ,
p_old_attribute9 => l_org_hist_csr.old_attribute9 ,
p_new_attribute9 => l_org_hist_csr.new_attribute9 ,
p_old_attribute10 => l_org_hist_csr.old_attribute10 ,
p_new_attribute10 => l_org_hist_csr.new_attribute10 ,
p_old_attribute11 => l_org_hist_csr.old_attribute11 ,
p_new_attribute11 => l_org_hist_csr.new_attribute11 ,
p_old_attribute12 => l_org_hist_csr.old_attribute12 ,
p_new_attribute12 => l_org_hist_csr.new_attribute12 ,
p_old_attribute13 => l_org_hist_csr.old_attribute13 ,
p_new_attribute13 => l_org_hist_csr.new_attribute13 ,
p_old_attribute14 => l_org_hist_csr.old_attribute14 ,
p_new_attribute14 => l_org_hist_csr.new_attribute14 ,
p_old_attribute15 => l_org_hist_csr.old_attribute15 ,
p_new_attribute15 => l_org_hist_csr.new_attribute15 ,
p_full_dump_flag => fnd_api.g_miss_char ,
p_created_by => fnd_api.g_miss_num ,
p_creation_date => fnd_api.g_miss_date ,
p_last_updated_by => fnd_global.user_id ,
p_last_update_date => sysdate ,
p_last_update_login => fnd_global.user_id ,
p_object_version_number => fnd_api.g_miss_num );
CSI_I_ORG_ASSIGNMENTS_H_PKG.Insert_Row(
l_csi_i_org_assign_h_id
,l_instance_ou_id
,p_txn_rec.TRANSACTION_ID
,l_org_unit_rec.OPERATING_UNIT_ID
,l_temp_org_unit_rec.OPERATING_UNIT_ID
,l_org_unit_rec.RELATIONSHIP_TYPE_CODE
,l_temp_org_unit_rec.RELATIONSHIP_TYPE_CODE
,l_org_unit_rec.ACTIVE_START_DATE
,l_temp_org_unit_rec.ACTIVE_START_DATE
,l_org_unit_rec.ACTIVE_END_DATE
,l_temp_org_unit_rec.ACTIVE_END_DATE
,l_org_unit_rec.context
,l_temp_org_unit_rec.context
,l_org_unit_rec.ATTRIBUTE1
,l_temp_org_unit_rec.ATTRIBUTE1
,l_org_unit_rec.ATTRIBUTE2
,l_temp_org_unit_rec.ATTRIBUTE2
,l_org_unit_rec.ATTRIBUTE3
,l_temp_org_unit_rec.ATTRIBUTE3
,l_org_unit_rec.ATTRIBUTE4
,l_temp_org_unit_rec.ATTRIBUTE4
,l_org_unit_rec.ATTRIBUTE5
,l_temp_org_unit_rec.ATTRIBUTE5
,l_org_unit_rec.ATTRIBUTE6
,l_temp_org_unit_rec.ATTRIBUTE6
,l_org_unit_rec.ATTRIBUTE7
,l_temp_org_unit_rec.ATTRIBUTE7
,l_org_unit_rec.ATTRIBUTE8
,l_temp_org_unit_rec.ATTRIBUTE8
,l_org_unit_rec.ATTRIBUTE9
,l_temp_org_unit_rec.ATTRIBUTE9
,l_org_unit_rec.ATTRIBUTE10
,l_temp_org_unit_rec.ATTRIBUTE10
,l_org_unit_rec.ATTRIBUTE11
,l_temp_org_unit_rec.ATTRIBUTE11
,l_org_unit_rec.ATTRIBUTE12
,l_temp_org_unit_rec.ATTRIBUTE12
,l_org_unit_rec.ATTRIBUTE13
,l_temp_org_unit_rec.ATTRIBUTE13
,l_org_unit_rec.ATTRIBUTE14
,l_temp_org_unit_rec.ATTRIBUTE14
,l_org_unit_rec.ATTRIBUTE15
,l_temp_org_unit_rec.ATTRIBUTE15
,l_dump_frequency_flag
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,1
);
CSI_I_ORG_ASSIGNMENTS_H_PKG.Insert_Row(
l_csi_i_org_assign_h_id
,l_instance_ou_id
,p_txn_rec.transaction_id
,l_org_units_hist_rec.old_operating_unit_id
,l_org_units_hist_rec.new_operating_unit_id
,l_org_units_hist_rec.old_relationship_type_code
,l_org_units_hist_rec.new_relationship_type_code
,l_org_units_hist_rec.old_active_start_date
,l_org_units_hist_rec.new_active_start_date
,l_org_units_hist_rec.old_active_end_date
,l_org_units_hist_rec.new_active_end_date
,l_org_units_hist_rec.old_context
,l_org_units_hist_rec.new_context
,l_org_units_hist_rec.old_attribute1
,l_org_units_hist_rec.new_attribute1
,l_org_units_hist_rec.old_attribute2
,l_org_units_hist_rec.new_attribute2
,l_org_units_hist_rec.old_attribute3
,l_org_units_hist_rec.new_attribute3
,l_org_units_hist_rec.old_attribute4
,l_org_units_hist_rec.new_attribute4
,l_org_units_hist_rec.old_attribute5
,l_org_units_hist_rec.new_attribute5
,l_org_units_hist_rec.old_attribute6
,l_org_units_hist_rec.new_attribute6
,l_org_units_hist_rec.old_attribute7
,l_org_units_hist_rec.new_attribute7
,l_org_units_hist_rec.old_attribute8
,l_org_units_hist_rec.new_attribute8
,l_org_units_hist_rec.old_attribute9
,l_org_units_hist_rec.new_attribute9
,l_org_units_hist_rec.old_attribute10
,l_org_units_hist_rec.new_attribute10
,l_org_units_hist_rec.old_attribute11
,l_org_units_hist_rec.new_attribute11
,l_org_units_hist_rec.old_attribute12
,l_org_units_hist_rec.new_attribute12
,l_org_units_hist_rec.old_attribute13
,l_org_units_hist_rec.new_attribute13
,l_org_units_hist_rec.old_attribute14
,l_org_units_hist_rec.new_attribute14
,l_org_units_hist_rec.old_attribute15
,l_org_units_hist_rec.new_attribute15
,l_dump_frequency_flag
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,1
);
ROLLBACK TO update_organization_unit;
ROLLBACK TO update_organization_unit;
ROLLBACK TO update_organization_unit;
END update_organization_unit;
csi_organization_unit_pvt.update_organization_unit
( p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_org_unit_rec => l_org_unit_rec
,p_txn_rec => p_txn_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_lookup_tbl => l_ou_lookup_tbl
,p_ou_count_rec => l_ou_count_rec
,p_ou_id_tbl => l_ou_id_tbl
);
SELECT oah.INSTANCE_OU_HISTORY_ID,
oah.INSTANCE_OU_ID ,
oah.TRANSACTION_ID ,
oah.OLD_OPERATING_UNIT_ID ,
oah.NEW_OPERATING_UNIT_ID ,
oah.OLD_RELATIONSHIP_TYPE_CODE,
oah.NEW_RELATIONSHIP_TYPE_CODE,
oah.OLD_ACTIVE_START_DATE,
oah.NEW_ACTIVE_START_DATE,
oah.OLD_ACTIVE_END_DATE,
oah.NEW_ACTIVE_END_DATE,
oah.OLD_CONTEXT ,
oah.NEW_CONTEXT ,
oah.OLD_ATTRIBUTE1 ,
oah.NEW_ATTRIBUTE1 ,
oah.OLD_ATTRIBUTE2 ,
oah.NEW_ATTRIBUTE2 ,
oah.OLD_ATTRIBUTE3 ,
oah.NEW_ATTRIBUTE3 ,
oah.OLD_ATTRIBUTE4 ,
oah.NEW_ATTRIBUTE4 ,
oah.OLD_ATTRIBUTE5 ,
oah.NEW_ATTRIBUTE5 ,
oah.OLD_ATTRIBUTE6 ,
oah.NEW_ATTRIBUTE6 ,
oah.OLD_ATTRIBUTE7 ,
oah.NEW_ATTRIBUTE7 ,
oah.OLD_ATTRIBUTE8 ,
oah.NEW_ATTRIBUTE8 ,
oah.OLD_ATTRIBUTE9 ,
oah.NEW_ATTRIBUTE9 ,
oah.OLD_ATTRIBUTE10 ,
oah.NEW_ATTRIBUTE10 ,
oah.OLD_ATTRIBUTE11 ,
oah.NEW_ATTRIBUTE11 ,
oah.OLD_ATTRIBUTE12 ,
oah.NEW_ATTRIBUTE12 ,
oah.OLD_ATTRIBUTE13 ,
oah.NEW_ATTRIBUTE13 ,
oah.OLD_ATTRIBUTE14 ,
oah.NEW_ATTRIBUTE14 ,
oah.OLD_ATTRIBUTE15 ,
oah.NEW_ATTRIBUTE15 ,
oah.FULL_DUMP_FLAG ,
oah.OBJECT_VERSION_NUMBER,
oa.INSTANCE_ID
FROM csi_i_org_assignments_h oah,
csi_i_org_assignments oa
WHERE oah.transaction_id = i_transaction_id
AND oah.instance_ou_id = oa.instance_ou_id;