APPS.HZ_MATCH_RULE_6 dependencies on HZ_PERSON_PROFILES

Line 414: FROM HZ_PERSON_PROFILES

410: and effective_end_date is null
411: and rownum = 1;
412: ELSIF l_party_type = 'PERSON' THEN
413: SELECT TAX_REFERENCE INTO l_matched_value
414: FROM HZ_PERSON_PROFILES
415: WHERE party_id = p_record_id
416: and effective_end_date is null
417: and rownum = 1;
418: END IF;

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

5815: AND HZ_PARTIES.party_id = p_party_id;
5816: ELSIF l_party_type = 'PERSON' THEN
5817: SELECT
5818: translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5819: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5820: INTO
5821: x_party_search_rec.PARTY_NAME
5822: ,x_party_search_rec.TAX_REFERENCE
5823: FROM HZ_PARTIES, HZ_PERSON_PROFILES

Line 5823: FROM HZ_PARTIES, HZ_PERSON_PROFILES

5819: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
5820: INTO
5821: x_party_search_rec.PARTY_NAME
5822: ,x_party_search_rec.TAX_REFERENCE
5823: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5824: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5825: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5826: AND HZ_PARTIES.party_id = p_party_id;
5827: END IF;

Line 5824: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

5820: INTO
5821: x_party_search_rec.PARTY_NAME
5822: ,x_party_search_rec.TAX_REFERENCE
5823: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5824: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5825: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5826: AND HZ_PARTIES.party_id = p_party_id;
5827: END IF;
5828: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 5825: AND HZ_PERSON_PROFILES.effective_end_date is NULL

5821: x_party_search_rec.PARTY_NAME
5822: ,x_party_search_rec.TAX_REFERENCE
5823: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5824: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5825: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5826: AND HZ_PARTIES.party_id = p_party_id;
5827: END IF;
5828: x_party_search_rec.PARTY_TYPE := l_party_type;
5829: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5910: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5906: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5907: ) IS
5908: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5909: SELECT org_contact_id
5910: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5911: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5912: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5913: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5914: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5916: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5912: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5913: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5914: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5915: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5916: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5917: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5918:
5919: I NUMBER;
5920: l_org_contact_id NUMBER;

Line 5917: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

5913: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5914: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5915: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5916: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5917: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5918:
5919: I NUMBER;
5920: l_org_contact_id NUMBER;
5921: J NUMBER:=1;