APPS.HZ_MATCH_RULE_41 dependencies on HZ_PERSON_PROFILES

Line 358: FROM HZ_PERSON_PROFILES

354: and effective_end_date is null
355: and rownum = 1;
356: ELSIF l_party_type = 'PERSON' THEN
357: SELECT TAX_REFERENCE INTO l_matched_value
358: FROM HZ_PERSON_PROFILES
359: WHERE party_id = p_record_id
360: and effective_end_date is null
361: and rownum = 1;
362: END IF;

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

5733: AND HZ_PARTIES.party_id = p_party_id;
5734: ELSIF l_party_type = 'PERSON' THEN
5735: SELECT
5736: translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5737: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5738: INTO
5739: x_party_search_rec.PARTY_NAME
5740: ,x_party_search_rec.TAX_REFERENCE
5741: FROM HZ_PARTIES, HZ_PERSON_PROFILES

Line 5741: FROM HZ_PARTIES, HZ_PERSON_PROFILES

5737: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5738: INTO
5739: x_party_search_rec.PARTY_NAME
5740: ,x_party_search_rec.TAX_REFERENCE
5741: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5742: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5743: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5744: AND HZ_PARTIES.party_id = p_party_id;
5745: END IF;

Line 5742: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

5738: INTO
5739: x_party_search_rec.PARTY_NAME
5740: ,x_party_search_rec.TAX_REFERENCE
5741: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5742: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5743: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5744: AND HZ_PARTIES.party_id = p_party_id;
5745: END IF;
5746: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 5743: AND HZ_PERSON_PROFILES.effective_end_date is NULL

5739: x_party_search_rec.PARTY_NAME
5740: ,x_party_search_rec.TAX_REFERENCE
5741: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5742: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5743: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5744: AND HZ_PARTIES.party_id = p_party_id;
5745: END IF;
5746: x_party_search_rec.PARTY_TYPE := l_party_type;
5747: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5828: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5824: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5825: ) IS
5826: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5827: SELECT org_contact_id
5828: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5829: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5830: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5831: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5832: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5834: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5830: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5831: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5832: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5833: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5834: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5835: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5836:
5837: I NUMBER;
5838: l_org_contact_id NUMBER;

Line 5835: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

5831: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5832: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5833: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5834: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5835: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5836:
5837: I NUMBER;
5838: l_org_contact_id NUMBER;
5839: J NUMBER:=1;