APPS.HZ_MATCH_RULE_4 dependencies on HZ_PERSON_PROFILES

Line 346: FROM HZ_PERSON_PROFILES

342: and effective_end_date is null
343: and rownum = 1;
344: ELSIF l_party_type = 'PERSON' THEN
345: SELECT TAX_REFERENCE INTO l_matched_value
346: FROM HZ_PERSON_PROFILES
347: WHERE party_id = p_record_id
348: and effective_end_date is null
349: and rownum = 1;
350: END IF;

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

5371: ELSIF l_party_type = 'PERSON' THEN
5372: SELECT
5373: translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5374: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5375: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5376: INTO
5377: x_party_search_rec.PARTY_NAME
5378: ,x_party_search_rec.PARTY_TYPE
5379: ,x_party_search_rec.TAX_REFERENCE

Line 5380: FROM HZ_PARTIES, HZ_PERSON_PROFILES

5376: INTO
5377: x_party_search_rec.PARTY_NAME
5378: ,x_party_search_rec.PARTY_TYPE
5379: ,x_party_search_rec.TAX_REFERENCE
5380: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5381: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5382: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5383: AND HZ_PARTIES.party_id = p_party_id;
5384: END IF;

Line 5381: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

5377: x_party_search_rec.PARTY_NAME
5378: ,x_party_search_rec.PARTY_TYPE
5379: ,x_party_search_rec.TAX_REFERENCE
5380: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5381: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5382: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5383: AND HZ_PARTIES.party_id = p_party_id;
5384: END IF;
5385: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 5382: AND HZ_PERSON_PROFILES.effective_end_date is NULL

5378: ,x_party_search_rec.PARTY_TYPE
5379: ,x_party_search_rec.TAX_REFERENCE
5380: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5381: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5382: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5383: AND HZ_PARTIES.party_id = p_party_id;
5384: END IF;
5385: x_party_search_rec.PARTY_TYPE := l_party_type;
5386: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5467: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5463: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5464: ) IS
5465: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5466: SELECT org_contact_id
5467: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5468: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5469: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5470: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5471: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5473: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5469: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5470: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5471: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5472: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5473: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5474: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5475:
5476: I NUMBER;
5477: l_org_contact_id NUMBER;

Line 5474: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

5470: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5471: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5472: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5473: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5474: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5475:
5476: I NUMBER;
5477: l_org_contact_id NUMBER;
5478: J NUMBER:=1;