APPS.HZ_MATCH_RULE_36 dependencies on HZ_PERSON_PROFILES

Line 5956: FROM HZ_PARTIES, HZ_PERSON_PROFILES

5952: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5953: INTO
5954: x_party_search_rec.PARTY_NUMBER
5955: ,x_party_search_rec.PARTY_TYPE
5956: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5957: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5958: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5959: AND HZ_PARTIES.party_id = p_party_id;
5960: END IF;

Line 5957: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

5953: INTO
5954: x_party_search_rec.PARTY_NUMBER
5955: ,x_party_search_rec.PARTY_TYPE
5956: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5957: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5958: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5959: AND HZ_PARTIES.party_id = p_party_id;
5960: END IF;
5961: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 5958: AND HZ_PERSON_PROFILES.effective_end_date is NULL

5954: x_party_search_rec.PARTY_NUMBER
5955: ,x_party_search_rec.PARTY_TYPE
5956: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5957: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5958: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5959: AND HZ_PARTIES.party_id = p_party_id;
5960: END IF;
5961: x_party_search_rec.PARTY_TYPE := l_party_type;
5962: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 6055: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

6051: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
6052: ) IS
6053: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
6054: SELECT org_contact_id
6055: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
6056: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
6057: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6058: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6059: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 6061: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

6057: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6058: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6059: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6060: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6061: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
6062: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
6063:
6064: I NUMBER;
6065: l_org_contact_id NUMBER;

Line 6062: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

6058: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6059: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6060: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6061: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
6062: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
6063:
6064: I NUMBER;
6065: l_org_contact_id NUMBER;
6066: J NUMBER:=1;