APPS.HZ_MATCH_RULE_53 dependencies on HZ_PERSON_PROFILES

Line 6012: FROM HZ_PARTIES, HZ_PERSON_PROFILES

6008: SELECT
6009: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6010: INTO
6011: x_party_search_rec.PARTY_NUMBER
6012: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6013: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6014: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6015: AND HZ_PARTIES.party_id = p_party_id;
6016: END IF;

Line 6013: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

6009: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6010: INTO
6011: x_party_search_rec.PARTY_NUMBER
6012: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6013: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6014: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6015: AND HZ_PARTIES.party_id = p_party_id;
6016: END IF;
6017: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 6014: AND HZ_PERSON_PROFILES.effective_end_date is NULL

6010: INTO
6011: x_party_search_rec.PARTY_NUMBER
6012: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6013: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6014: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6015: AND HZ_PARTIES.party_id = p_party_id;
6016: END IF;
6017: x_party_search_rec.PARTY_TYPE := l_party_type;
6018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 6111: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

6107: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
6108: ) IS
6109: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
6110: SELECT org_contact_id
6111: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
6112: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
6113: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6114: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6115: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 6117: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

6113: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6114: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6115: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6116: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6117: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
6118: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
6119:
6120: I NUMBER;
6121: l_org_contact_id NUMBER;

Line 6118: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

6114: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6115: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6116: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6117: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
6118: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
6119:
6120: I NUMBER;
6121: l_org_contact_id NUMBER;
6122: J NUMBER:=1;