805: FETCH c_party_type INTO l_party_type,l_object_version_number,l_sic_code_type,l_sic_code;
806: CLOSE c_party_type;
807:
808: IF l_party_type = 'PERSON' THEN
809: HZ_DQM_SYNC.sync_person(p_code_assignment_rec.owner_table_id, 'C');
810: ELSIF l_party_type = 'ORGANIZATION' THEN
811: HZ_DQM_SYNC.sync_org(p_code_assignment_rec.owner_table_id, 'C');
812: END IF;
813:
807:
808: IF l_party_type = 'PERSON' THEN
809: HZ_DQM_SYNC.sync_person(p_code_assignment_rec.owner_table_id, 'C');
810: ELSIF l_party_type = 'ORGANIZATION' THEN
811: HZ_DQM_SYNC.sync_org(p_code_assignment_rec.owner_table_id, 'C');
812: END IF;
813:
814: END IF;
815: END IF;
1216: CLOSE c_party_type;
1217:
1218:
1219: IF l_party_type = 'PERSON' THEN
1220: HZ_DQM_SYNC.sync_person(p_code_assignment_rec.owner_table_id, 'U');
1221: ELSIF l_party_type = 'ORGANIZATION' THEN
1222: HZ_DQM_SYNC.sync_org(p_code_assignment_rec.owner_table_id, 'U');
1223: END IF;
1224:
1218:
1219: IF l_party_type = 'PERSON' THEN
1220: HZ_DQM_SYNC.sync_person(p_code_assignment_rec.owner_table_id, 'U');
1221: ELSIF l_party_type = 'ORGANIZATION' THEN
1222: HZ_DQM_SYNC.sync_org(p_code_assignment_rec.owner_table_id, 'U');
1223: END IF;
1224:
1225:
1226: END IF;