APPS.HZ_MATCH_RULE_62 dependencies on HZ_PERSON_PROFILES

Line 473: FROM HZ_PERSON_PROFILES

469: and effective_end_date is null
470: and rownum = 1;
471: ELSIF l_party_type = 'PERSON' THEN
472: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
473: FROM HZ_PERSON_PROFILES
474: WHERE party_id = p_record_id
475: and effective_end_date is null
476: and rownum = 1;
477: END IF;

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

6378: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6379: AND HZ_PARTIES.party_id = p_party_id;
6380: ELSIF l_party_type = 'PERSON' THEN
6381: SELECT
6382: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6383: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6384: INTO
6385: x_party_search_rec.JGZZ_FISCAL_CODE
6386: ,x_party_search_rec.PARTY_NUMBER

Line 6387: FROM HZ_PARTIES, HZ_PERSON_PROFILES

6383: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6384: INTO
6385: x_party_search_rec.JGZZ_FISCAL_CODE
6386: ,x_party_search_rec.PARTY_NUMBER
6387: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6388: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6389: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6390: AND HZ_PARTIES.party_id = p_party_id;
6391: END IF;

Line 6388: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

6384: INTO
6385: x_party_search_rec.JGZZ_FISCAL_CODE
6386: ,x_party_search_rec.PARTY_NUMBER
6387: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6388: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6389: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6390: AND HZ_PARTIES.party_id = p_party_id;
6391: END IF;
6392: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 6389: AND HZ_PERSON_PROFILES.effective_end_date is NULL

6385: x_party_search_rec.JGZZ_FISCAL_CODE
6386: ,x_party_search_rec.PARTY_NUMBER
6387: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6388: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6389: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6390: AND HZ_PARTIES.party_id = p_party_id;
6391: END IF;
6392: x_party_search_rec.PARTY_TYPE := l_party_type;
6393: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 6486: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

6482: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
6483: ) IS
6484: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
6485: SELECT org_contact_id
6486: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
6487: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
6488: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6489: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6490: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 6492: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

6488: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6489: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6490: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6491: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6492: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
6493: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
6494:
6495: I NUMBER;
6496: l_org_contact_id NUMBER;

Line 6493: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

6489: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6490: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6491: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6492: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
6493: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
6494:
6495: I NUMBER;
6496: l_org_contact_id NUMBER;
6497: J NUMBER:=1;