APPS.HZ_PARTY_MERGE dependencies on HZ_PERSON_PROFILES

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

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

Line 2270: l_entity_name = 'HZ_PERSON_PROFILES' OR

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

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

4298:
4299: cursor person_c(l_dup_set_id in NUMBER)
4300: is
4301: select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4302: from HZ_merge_parties dup, hz_parties hp, hz_person_profiles orgpf
4303: where dup.batch_id = l_dup_set_id
4304: and (hp.party_id = dup.from_party_id or hp.party_id = dup.to_party_id)
4305: and hp.party_type = 'PERSON'
4306: and hp.party_id = orgpf.party_id(+)

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

4306: and hp.party_id = orgpf.party_id(+)
4307: and sysdate between orgpf.effective_start_date(+) and nvl(orgpf.effective_end_date(+),sysdate);
4308:
4309: /* select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4310: from HZ_DUP_SET_PARTIES dup, hz_parties hp, hz_person_profiles orgpf
4311: where dup.dup_set_id = l_dup_set_id
4312: and dup.dup_party_id = hp.party_id
4313: and hp.party_type = 'PERSON'
4314: and hp.party_id = orgpf.party_id(+)