APPS.HZ_MATCH_RULE_7 dependencies on HZ_PERSON_PROFILES

Line 367: FROM HZ_PERSON_PROFILES

363: and effective_end_date is null
364: and rownum = 1;
365: ELSIF l_party_type = 'PERSON' THEN
366: SELECT TAX_REFERENCE INTO l_matched_value
367: FROM HZ_PERSON_PROFILES
368: WHERE party_id = p_record_id
369: and effective_end_date is null
370: and rownum = 1;
371: END IF;

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

5613: AND HZ_PARTIES.party_id = p_party_id;
5614: ELSIF l_party_type = 'PERSON' THEN
5615: SELECT
5616: translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5617: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5618: INTO
5619: x_party_search_rec.PARTY_NAME
5620: ,x_party_search_rec.TAX_REFERENCE
5621: FROM HZ_PARTIES, HZ_PERSON_PROFILES

Line 5621: FROM HZ_PARTIES, HZ_PERSON_PROFILES

5617: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5618: INTO
5619: x_party_search_rec.PARTY_NAME
5620: ,x_party_search_rec.TAX_REFERENCE
5621: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5622: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5623: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5624: AND HZ_PARTIES.party_id = p_party_id;
5625: END IF;

Line 5622: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

5618: INTO
5619: x_party_search_rec.PARTY_NAME
5620: ,x_party_search_rec.TAX_REFERENCE
5621: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5622: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5623: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5624: AND HZ_PARTIES.party_id = p_party_id;
5625: END IF;
5626: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 5623: AND HZ_PERSON_PROFILES.effective_end_date is NULL

5619: x_party_search_rec.PARTY_NAME
5620: ,x_party_search_rec.TAX_REFERENCE
5621: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5622: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5623: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5624: AND HZ_PARTIES.party_id = p_party_id;
5625: END IF;
5626: x_party_search_rec.PARTY_TYPE := l_party_type;
5627: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5708: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5704: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5705: ) IS
5706: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5707: SELECT org_contact_id
5708: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5709: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5710: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5711: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5712: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5714: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5710: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5711: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5712: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5713: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5714: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5715: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5716:
5717: I NUMBER;
5718: l_org_contact_id NUMBER;

Line 5715: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

5711: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5712: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5713: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5714: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5715: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5716:
5717: I NUMBER;
5718: l_org_contact_id NUMBER;
5719: J NUMBER:=1;