APPS.HZ_MATCH_RULE_2 dependencies on HZ_PERSON_PROFILES

Line 325: FROM HZ_PERSON_PROFILES

321: and effective_end_date is null
322: and rownum = 1;
323: ELSIF l_party_type = 'PERSON' THEN
324: SELECT TAX_REFERENCE INTO l_matched_value
325: FROM HZ_PERSON_PROFILES
326: WHERE party_id = p_record_id
327: and effective_end_date is null
328: and rownum = 1;
329: END IF;

Line 5348: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')

5344: AND HZ_PARTIES.party_id = p_party_id;
5345: ELSIF l_party_type = 'PERSON' THEN
5346: SELECT
5347: translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5348: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5349: INTO
5350: x_party_search_rec.PARTY_TYPE
5351: ,x_party_search_rec.TAX_REFERENCE
5352: FROM HZ_PARTIES, HZ_PERSON_PROFILES

Line 5352: FROM HZ_PARTIES, HZ_PERSON_PROFILES

5348: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5349: INTO
5350: x_party_search_rec.PARTY_TYPE
5351: ,x_party_search_rec.TAX_REFERENCE
5352: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5353: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5354: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5355: AND HZ_PARTIES.party_id = p_party_id;
5356: END IF;

Line 5353: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

5349: INTO
5350: x_party_search_rec.PARTY_TYPE
5351: ,x_party_search_rec.TAX_REFERENCE
5352: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5353: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5354: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5355: AND HZ_PARTIES.party_id = p_party_id;
5356: END IF;
5357: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 5354: AND HZ_PERSON_PROFILES.effective_end_date is NULL

5350: x_party_search_rec.PARTY_TYPE
5351: ,x_party_search_rec.TAX_REFERENCE
5352: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5353: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5354: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5355: AND HZ_PARTIES.party_id = p_party_id;
5356: END IF;
5357: x_party_search_rec.PARTY_TYPE := l_party_type;
5358: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5439: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5435: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5436: ) IS
5437: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5438: SELECT org_contact_id
5439: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5440: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5441: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5442: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5443: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5445: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5441: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5442: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5443: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5444: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5445: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5446: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5447:
5448: I NUMBER;
5449: l_org_contact_id NUMBER;

Line 5446: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

5442: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5443: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5444: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5445: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5446: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5447:
5448: I NUMBER;
5449: l_org_contact_id NUMBER;
5450: J NUMBER:=1;