APPS.HZ_PARTY_MERGE dependencies on HZ_PERSON_PROFILES

Line 1023: SELECT decode(party_type,'PERSON','HZ_PERSON_PROFILES',

1019: WHERE merge_to_party_id = l_pre_merge_to_party_id
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;

Line 2230: l_entity_name = 'HZ_PERSON_PROFILES' OR

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
2234: rec_delete := 'UPDATE ' || l_entity_name ||

Line 4704: from HZ_merge_parties dup, hz_parties hp, hz_person_profiles orgpf

4700:
4701: cursor person_c(l_dup_set_id in NUMBER)
4702: is
4703: select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4704: from HZ_merge_parties dup, hz_parties hp, hz_person_profiles orgpf
4705: where dup.batch_id = l_dup_set_id
4706: and (hp.party_id = dup.from_party_id or hp.party_id = dup.to_party_id)
4707: and hp.party_type = 'PERSON'
4708: and hp.party_id = orgpf.party_id(+)

Line 4712: from HZ_DUP_SET_PARTIES dup, hz_parties hp, hz_person_profiles orgpf

4708: and hp.party_id = orgpf.party_id(+)
4709: and sysdate between orgpf.effective_start_date(+) and nvl(orgpf.effective_end_date(+),sysdate);
4710:
4711: /* select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4712: from HZ_DUP_SET_PARTIES dup, hz_parties hp, hz_person_profiles orgpf
4713: where dup.dup_set_id = l_dup_set_id
4714: and dup.dup_party_id = hp.party_id
4715: and hp.party_type = 'PERSON'
4716: and hp.party_id = orgpf.party_id(+)