APPS.HZ_MATCH_RULE_40 dependencies on HZ_PERSON_PROFILES

Line 374: FROM HZ_PERSON_PROFILES

370: and effective_end_date is null
371: and rownum = 1;
372: ELSIF l_party_type = 'PERSON' THEN
373: SELECT TAX_REFERENCE INTO l_matched_value
374: FROM HZ_PERSON_PROFILES
375: WHERE party_id = p_record_id
376: and effective_end_date is null
377: and rownum = 1;
378: END IF;

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

5853: AND HZ_PARTIES.party_id = p_party_id;
5854: ELSIF l_party_type = 'PERSON' THEN
5855: SELECT
5856: translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5857: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5858: INTO
5859: x_party_search_rec.PARTY_TYPE
5860: ,x_party_search_rec.TAX_REFERENCE
5861: FROM HZ_PARTIES, HZ_PERSON_PROFILES

Line 5861: FROM HZ_PARTIES, HZ_PERSON_PROFILES

5857: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5858: INTO
5859: x_party_search_rec.PARTY_TYPE
5860: ,x_party_search_rec.TAX_REFERENCE
5861: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5862: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5863: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5864: AND HZ_PARTIES.party_id = p_party_id;
5865: END IF;

Line 5862: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

5858: INTO
5859: x_party_search_rec.PARTY_TYPE
5860: ,x_party_search_rec.TAX_REFERENCE
5861: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5862: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5863: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5864: AND HZ_PARTIES.party_id = p_party_id;
5865: END IF;
5866: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 5863: AND HZ_PERSON_PROFILES.effective_end_date is NULL

5859: x_party_search_rec.PARTY_TYPE
5860: ,x_party_search_rec.TAX_REFERENCE
5861: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5862: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5863: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5864: AND HZ_PARTIES.party_id = p_party_id;
5865: END IF;
5866: x_party_search_rec.PARTY_TYPE := l_party_type;
5867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5950: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5946: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5947: ) IS
5948: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5949: SELECT org_contact_id
5950: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5951: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5952: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5953: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5954: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5956: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5952: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5953: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5954: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5955: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5956: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5957: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5958:
5959: I NUMBER;
5960: l_org_contact_id NUMBER;

Line 5957: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

5953: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5954: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5955: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5956: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5957: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5958:
5959: I NUMBER;
5960: l_org_contact_id NUMBER;
5961: J NUMBER:=1;