APPS.HZ_MATCH_RULE_39 dependencies on HZ_PERSON_PROFILES

Line 342: FROM HZ_PERSON_PROFILES

338: and effective_end_date is null
339: and rownum = 1;
340: ELSIF l_party_type = 'PERSON' THEN
341: SELECT TAX_REFERENCE INTO l_matched_value
342: FROM HZ_PERSON_PROFILES
343: WHERE party_id = p_record_id
344: and effective_end_date is null
345: and rownum = 1;
346: END IF;

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

5460: AND HZ_PARTIES.party_id = p_party_id;
5461: ELSIF l_party_type = 'PERSON' THEN
5462: SELECT
5463: translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5464: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5465: INTO
5466: x_party_search_rec.PARTY_TYPE
5467: ,x_party_search_rec.TAX_REFERENCE
5468: FROM HZ_PARTIES, HZ_PERSON_PROFILES

Line 5468: FROM HZ_PARTIES, HZ_PERSON_PROFILES

5464: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5465: INTO
5466: x_party_search_rec.PARTY_TYPE
5467: ,x_party_search_rec.TAX_REFERENCE
5468: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5469: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5470: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5471: AND HZ_PARTIES.party_id = p_party_id;
5472: END IF;

Line 5469: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

5465: INTO
5466: x_party_search_rec.PARTY_TYPE
5467: ,x_party_search_rec.TAX_REFERENCE
5468: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5469: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5470: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5471: AND HZ_PARTIES.party_id = p_party_id;
5472: END IF;
5473: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 5470: AND HZ_PERSON_PROFILES.effective_end_date is NULL

5466: x_party_search_rec.PARTY_TYPE
5467: ,x_party_search_rec.TAX_REFERENCE
5468: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5469: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5470: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5471: AND HZ_PARTIES.party_id = p_party_id;
5472: END IF;
5473: x_party_search_rec.PARTY_TYPE := l_party_type;
5474: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5557: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5553: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5554: ) IS
5555: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5556: SELECT org_contact_id
5557: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5558: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5559: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5560: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5561: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5563: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5559: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5560: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5561: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5562: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5563: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5564: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5565:
5566: I NUMBER;
5567: l_org_contact_id NUMBER;

Line 5564: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

5560: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5561: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5562: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5563: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5564: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5565:
5566: I NUMBER;
5567: l_org_contact_id NUMBER;
5568: J NUMBER:=1;