APPS.HZ_PARTY_MERGE dependencies on HZ_ORGANIZATION_PROFILES

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

311:
312: -----Cursor to get merge from-merge to pair parties and the type-----
313: CURSOR c_batch_details(cp_batch_id NUMBER,cp_to_party_id IN NUMBER) IS
314: SELECT batch_party_id, merge_type, from_party_id, to_party_id, merge_status,party_type, decode(op.actual_content_source, 'DNB', 'DNB', NULL)
315: FROM HZ_MERGE_PARTIES mp, HZ_PARTIES pt, hz_organization_profiles op
316: WHERE batch_id = cp_batch_id
317: AND pt.party_id = mp.from_party_id
318: AND op.party_id(+) = pt.party_id
319: AND op.actual_content_source(+) = 'DNB'

Line 1024: 'ORGANIZATION','HZ_ORGANIZATION_PROFILES',

1020: AND merge_batch_id = l_batch_id
1021: AND ROWNUM=1;
1022:
1023: SELECT decode(party_type,'PERSON','HZ_PERSON_PROFILES',
1024: 'ORGANIZATION','HZ_ORGANIZATION_PROFILES',
1025: 'HZ_ORGANIZATION_PROFILES') INTO l_party_type
1026: FROM HZ_PARTIES
1027: WHERE party_id=l_pre_merge_to_party_id;
1028:

Line 1025: 'HZ_ORGANIZATION_PROFILES') INTO l_party_type

1021: AND ROWNUM=1;
1022:
1023: SELECT decode(party_type,'PERSON','HZ_PERSON_PROFILES',
1024: 'ORGANIZATION','HZ_ORGANIZATION_PROFILES',
1025: 'HZ_ORGANIZATION_PROFILES') INTO l_party_type
1026: FROM HZ_PARTIES
1027: WHERE party_id=l_pre_merge_to_party_id;
1028:
1029:

Line 2229: l_entity_name = 'HZ_ORGANIZATION_PROFILES' OR

2225: EXIT WHEN c_deleted_records%NOTFOUND;
2226:
2227: IF l_entity_name = 'HZ_PARTIES' OR
2228: l_entity_name = 'HZ_PARTY_SITES' OR
2229: l_entity_name = 'HZ_ORGANIZATION_PROFILES' OR
2230: l_entity_name = 'HZ_PERSON_PROFILES' OR
2231: l_entity_name = 'HZ_ORG_CONTACTS' OR
2232: l_entity_name = 'HZ_PARTY_USG_ASSIGNMENTS' --4307667
2233: THEN

Line 3385: FROM HZ_ORGANIZATION_PROFILES

3381: WHERE party_id = cp_party_id;
3382:
3383: CURSOR c_duns IS
3384: SELECT duns_number_c, last_update_date, organization_profile_id,actual_content_source
3385: FROM HZ_ORGANIZATION_PROFILES
3386: WHERE party_id = p_from_id
3387: AND EFFECTIVE_END_DATE IS NULL
3388: AND actual_content_source = 'DNB'
3389: AND nvl(status, 'A') = 'A';

Line 3393: FROM HZ_ORGANIZATION_PROFILES

3389: AND nvl(status, 'A') = 'A';
3390:
3391: CURSOR c_duns1 IS
3392: SELECT duns_number_c , last_update_date, organization_profile_id,actual_content_source
3393: FROM HZ_ORGANIZATION_PROFILES
3394: WHERE party_id = x_to_id
3395: AND EFFECTIVE_END_DATE IS NULL
3396: AND actual_content_source = 'DNB'
3397: AND nvl(status, 'A') = 'A';

Line 3505: -- Handle DNB data in HZ_ORGANIZATION_PROFILES

3501: -- indicate how the DNB data needs to be handled.
3502: if case1 OR case2 OR case3 THEN
3503:
3504: -- *******************************************
3505: -- Handle DNB data in HZ_ORGANIZATION_PROFILES
3506:
3507: IF case1 OR (case3 and l_to_is_branch = 'Y') THEN
3508: HZ_PARTY_V2PUB.get_organization_rec(
3509: FND_API.G_FALSE,

Line 3562: 'HZ_ORGANIZATION_PROFILES',

3558: END IF;
3559:
3560: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3561: p_batch_party_id,
3562: 'HZ_ORGANIZATION_PROFILES',
3563: l_from_profile_id,
3564: l_to_profile_id,
3565: 'Y',
3566: hz_utility_pub.created_by,

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

4678:
4679: cursor org_c(l_dup_set_id in NUMBER)
4680: is
4681: select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4682: from HZ_merge_parties dup, hz_parties hp, hz_organization_profiles orgpf
4683: where dup.batch_id = l_dup_set_id
4684: and (hp.party_id = dup.from_party_id or hp.party_id = dup.to_party_id)
4685: and hp.party_type = 'ORGANIZATION'
4686: and hp.party_id = orgpf.party_id(+)

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

4686: and hp.party_id = orgpf.party_id(+)
4687: and sysdate between orgpf.effective_start_date(+) and nvl(orgpf.effective_end_date(+),sysdate);
4688:
4689: /* select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4690: from HZ_DUP_SET_PARTIES dup, hz_parties hp, hz_organization_profiles orgpf
4691: where dup.dup_set_id = l_dup_set_id
4692: and dup.dup_party_id = hp.party_id
4693: and hp.party_type = 'ORGANIZATION'
4694: and hp.party_id = orgpf.party_id(+)