APPS.HZ_MATCH_RULE_3 dependencies on HZ_PERSON_PROFILES

Line 297: FROM HZ_PERSON_PROFILES

293: and effective_end_date is null
294: and rownum = 1;
295: ELSIF l_party_type = 'PERSON' THEN
296: SELECT TAX_REFERENCE INTO l_matched_value
297: FROM HZ_PERSON_PROFILES
298: WHERE party_id = p_record_id
299: and effective_end_date is null
300: and rownum = 1;
301: END IF;

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

5294: AND HZ_PARTIES.party_id = p_party_id;
5295: ELSIF l_party_type = 'PERSON' THEN
5296: SELECT
5297: translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5298: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5299: INTO
5300: x_party_search_rec.PARTY_TYPE
5301: ,x_party_search_rec.TAX_REFERENCE
5302: FROM HZ_PARTIES, HZ_PERSON_PROFILES

Line 5302: FROM HZ_PARTIES, HZ_PERSON_PROFILES

5298: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5299: INTO
5300: x_party_search_rec.PARTY_TYPE
5301: ,x_party_search_rec.TAX_REFERENCE
5302: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5303: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5304: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5305: AND HZ_PARTIES.party_id = p_party_id;
5306: END IF;

Line 5303: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

5299: INTO
5300: x_party_search_rec.PARTY_TYPE
5301: ,x_party_search_rec.TAX_REFERENCE
5302: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5303: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5304: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5305: AND HZ_PARTIES.party_id = p_party_id;
5306: END IF;
5307: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 5304: AND HZ_PERSON_PROFILES.effective_end_date is NULL

5300: x_party_search_rec.PARTY_TYPE
5301: ,x_party_search_rec.TAX_REFERENCE
5302: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5303: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5304: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5305: AND HZ_PARTIES.party_id = p_party_id;
5306: END IF;
5307: x_party_search_rec.PARTY_TYPE := l_party_type;
5308: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5385: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5381: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5382: ) IS
5383: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5384: SELECT org_contact_id
5385: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5386: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5387: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5388: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5389: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5391: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5387: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5388: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5389: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5390: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5391: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5392: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5393:
5394: I NUMBER;
5395: l_org_contact_id NUMBER;

Line 5392: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

5388: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5389: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5390: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5391: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5392: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5393:
5394: I NUMBER;
5395: l_org_contact_id NUMBER;
5396: J NUMBER:=1;