APPS.HZ_PARTY_MERGE dependencies on HZ_ORGANIZATION_PROFILES

Line 335: FROM HZ_MERGE_PARTIES mp, HZ_PARTIES pt, hz_organization_profiles op

331: -----Cursor to get merge from-merge to pair parties and the type-----
332: CURSOR c_batch_details(cp_batch_id NUMBER,cp_to_party_id IN NUMBER) IS
333: SELECT batch_party_id, merge_type, from_party_id, to_party_id, merge_status,party_type,
334: decode(op.actual_content_source, 'DNB', 'DNB', NULL), merge_reason_code
335: FROM HZ_MERGE_PARTIES mp, HZ_PARTIES pt, hz_organization_profiles op
336: WHERE batch_id = cp_batch_id
337: AND pt.party_id = mp.from_party_id
338: AND op.party_id(+) = pt.party_id
339: AND op.actual_content_source(+) = 'DNB'

Line 1061: 'ORGANIZATION','HZ_ORGANIZATION_PROFILES',

1057: AND merge_batch_id = l_batch_id
1058: AND ROWNUM=1;
1059:
1060: SELECT decode(party_type,'PERSON','HZ_PERSON_PROFILES',
1061: 'ORGANIZATION','HZ_ORGANIZATION_PROFILES',
1062: 'HZ_ORGANIZATION_PROFILES') INTO l_party_type
1063: FROM HZ_PARTIES
1064: WHERE party_id=l_pre_merge_to_party_id;
1065:

Line 1062: 'HZ_ORGANIZATION_PROFILES') INTO l_party_type

1058: AND ROWNUM=1;
1059:
1060: SELECT decode(party_type,'PERSON','HZ_PERSON_PROFILES',
1061: 'ORGANIZATION','HZ_ORGANIZATION_PROFILES',
1062: 'HZ_ORGANIZATION_PROFILES') INTO l_party_type
1063: FROM HZ_PARTIES
1064: WHERE party_id=l_pre_merge_to_party_id;
1065:
1066:

Line 2269: l_entity_name = 'HZ_ORGANIZATION_PROFILES' OR

2265: EXIT WHEN c_deleted_records%NOTFOUND;
2266:
2267: IF l_entity_name = 'HZ_PARTIES' OR
2268: l_entity_name = 'HZ_PARTY_SITES' OR
2269: l_entity_name = 'HZ_ORGANIZATION_PROFILES' OR
2270: l_entity_name = 'HZ_PERSON_PROFILES' OR
2271: l_entity_name = 'HZ_ORG_CONTACTS' OR
2272: l_entity_name = 'HZ_PARTY_USG_ASSIGNMENTS' --4307667
2273: THEN

Line 3425: FROM HZ_ORGANIZATION_PROFILES

3421: WHERE party_id = cp_party_id;
3422:
3423: CURSOR c_duns IS
3424: SELECT duns_number_c, last_update_date, organization_profile_id,actual_content_source
3425: FROM HZ_ORGANIZATION_PROFILES
3426: WHERE party_id = p_from_id
3427: AND EFFECTIVE_END_DATE IS NULL
3428: AND actual_content_source = 'DNB'
3429: AND nvl(status, 'A') = 'A';

Line 3433: FROM HZ_ORGANIZATION_PROFILES

3429: AND nvl(status, 'A') = 'A';
3430:
3431: CURSOR c_duns1 IS
3432: SELECT duns_number_c , last_update_date, organization_profile_id,actual_content_source
3433: FROM HZ_ORGANIZATION_PROFILES
3434: WHERE party_id = x_to_id
3435: AND EFFECTIVE_END_DATE IS NULL
3436: AND actual_content_source = 'DNB'
3437: AND nvl(status, 'A') = 'A';

Line 3528: -- Handle DNB data in HZ_ORGANIZATION_PROFILES

3524: -- indicate how the DNB data needs to be handled.
3525: if case1 OR case2 OR case3 THEN
3526:
3527: -- *******************************************
3528: -- Handle DNB data in HZ_ORGANIZATION_PROFILES
3529:
3530: IF case1 OR (case3 and l_to_is_branch = 'Y') THEN
3531: HZ_PARTY_V2PUB.get_organization_rec(
3532: FND_API.G_FALSE,

Line 3585: 'HZ_ORGANIZATION_PROFILES',

3581: END IF;
3582:
3583: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3584: p_batch_party_id,
3585: 'HZ_ORGANIZATION_PROFILES',
3586: l_from_profile_id,
3587: l_to_profile_id,
3588: 'Y',
3589: hz_utility_pub.created_by,

Line 4280: from HZ_merge_parties dup, hz_parties hp, hz_organization_profiles orgpf

4276:
4277: cursor org_c(l_dup_set_id in NUMBER)
4278: is
4279: select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4280: from HZ_merge_parties dup, hz_parties hp, hz_organization_profiles orgpf
4281: where dup.batch_id = l_dup_set_id
4282: and (hp.party_id = dup.from_party_id or hp.party_id = dup.to_party_id)
4283: and hp.party_type = 'ORGANIZATION'
4284: and hp.party_id = orgpf.party_id(+)

Line 4288: from HZ_DUP_SET_PARTIES dup, hz_parties hp, hz_organization_profiles orgpf

4284: and hp.party_id = orgpf.party_id(+)
4285: and sysdate between orgpf.effective_start_date(+) and nvl(orgpf.effective_end_date(+),sysdate);
4286:
4287: /* select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4288: from HZ_DUP_SET_PARTIES dup, hz_parties hp, hz_organization_profiles orgpf
4289: where dup.dup_set_id = l_dup_set_id
4290: and dup.dup_party_id = hp.party_id
4291: and hp.party_type = 'ORGANIZATION'
4292: and hp.party_id = orgpf.party_id(+)