APPS.HZ_MATCH_RULE_5 dependencies on HZ_PERSON_PROFILES

Line 5246: FROM HZ_PARTIES, HZ_PERSON_PROFILES

5242: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5243: INTO
5244: x_party_search_rec.PARTY_NAME
5245: ,x_party_search_rec.PARTY_TYPE
5246: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5247: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5248: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5249: AND HZ_PARTIES.party_id = p_party_id;
5250: END IF;

Line 5247: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

5243: INTO
5244: x_party_search_rec.PARTY_NAME
5245: ,x_party_search_rec.PARTY_TYPE
5246: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5247: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5248: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5249: AND HZ_PARTIES.party_id = p_party_id;
5250: END IF;
5251: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 5248: AND HZ_PERSON_PROFILES.effective_end_date is NULL

5244: x_party_search_rec.PARTY_NAME
5245: ,x_party_search_rec.PARTY_TYPE
5246: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5247: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5248: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5249: AND HZ_PARTIES.party_id = p_party_id;
5250: END IF;
5251: x_party_search_rec.PARTY_TYPE := l_party_type;
5252: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5333: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5329: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5330: ) IS
5331: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5332: SELECT org_contact_id
5333: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5334: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5335: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5336: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5337: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5339: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5335: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5336: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5337: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5338: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5339: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5340: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5341:
5342: I NUMBER;
5343: l_org_contact_id NUMBER;

Line 5340: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

5336: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5337: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5338: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5339: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5340: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5341:
5342: I NUMBER;
5343: l_org_contact_id NUMBER;
5344: J NUMBER:=1;