APPS.HZ_MATCH_RULE_238 dependencies on HZ_PERSON_PROFILES

Line 335: FROM HZ_PERSON_PROFILES

331: and effective_end_date is null
332: and rownum = 1;
333: ELSIF l_party_type = 'PERSON' THEN
334: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
335: FROM HZ_PERSON_PROFILES
336: WHERE party_id = p_record_id
337: and effective_end_date is null
338: and rownum = 1;
339: END IF;

Line 5690: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')

5686: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5687: AND HZ_PARTIES.party_id = p_party_id;
5688: ELSIF l_party_type = 'PERSON' THEN
5689: SELECT
5690: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
5691: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5692: INTO
5693: x_party_search_rec.JGZZ_FISCAL_CODE
5694: ,x_party_search_rec.PARTY_NAME

Line 5695: FROM HZ_PARTIES, HZ_PERSON_PROFILES

5691: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5692: INTO
5693: x_party_search_rec.JGZZ_FISCAL_CODE
5694: ,x_party_search_rec.PARTY_NAME
5695: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5696: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5697: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5698: AND HZ_PARTIES.party_id = p_party_id;
5699: END IF;

Line 5696: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

5692: INTO
5693: x_party_search_rec.JGZZ_FISCAL_CODE
5694: ,x_party_search_rec.PARTY_NAME
5695: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5696: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5697: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5698: AND HZ_PARTIES.party_id = p_party_id;
5699: END IF;
5700: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 5697: AND HZ_PERSON_PROFILES.effective_end_date is NULL

5693: x_party_search_rec.JGZZ_FISCAL_CODE
5694: ,x_party_search_rec.PARTY_NAME
5695: FROM HZ_PARTIES, HZ_PERSON_PROFILES
5696: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
5697: AND HZ_PERSON_PROFILES.effective_end_date is NULL
5698: AND HZ_PARTIES.party_id = p_party_id;
5699: END IF;
5700: x_party_search_rec.PARTY_TYPE := l_party_type;
5701: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5782: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5778: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5779: ) IS
5780: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5781: SELECT org_contact_id
5782: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5783: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5784: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5785: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5786: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5788: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5784: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5785: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5786: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5787: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5788: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5789: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5790:
5791: I NUMBER;
5792: l_org_contact_id NUMBER;

Line 5789: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

5785: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5786: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5787: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5788: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5789: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5790:
5791: I NUMBER;
5792: l_org_contact_id NUMBER;
5793: J NUMBER:=1;