APPS.HZ_MATCH_RULE_32 dependencies on HZ_PERSON_PROFILES

Line 466: FROM HZ_PERSON_PROFILES

462: and effective_end_date is null
463: and rownum = 1;
464: ELSIF l_party_type = 'PERSON' THEN
465: SELECT TAX_REFERENCE INTO l_matched_value
466: FROM HZ_PERSON_PROFILES
467: WHERE party_id = p_record_id
468: and effective_end_date is null
469: and rownum = 1;
470: END IF;

Line 504: FROM HZ_PERSON_PROFILES

500: and effective_end_date is null
501: and rownum = 1;
502: ELSIF l_party_type = 'PERSON' THEN
503: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
504: FROM HZ_PERSON_PROFILES
505: WHERE party_id = p_record_id
506: and effective_end_date is null
507: and rownum = 1;
508: END IF;

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

6566: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6567: AND HZ_PARTIES.party_id = p_party_id;
6568: ELSIF l_party_type = 'PERSON' THEN
6569: SELECT
6570: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6571: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6572: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6573: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
6574: INTO

Line 6573: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')

6569: SELECT
6570: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6571: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6572: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6573: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
6574: INTO
6575: x_party_search_rec.JGZZ_FISCAL_CODE
6576: ,x_party_search_rec.PARTY_NUMBER
6577: ,x_party_search_rec.PARTY_TYPE

Line 6579: FROM HZ_PARTIES, HZ_PERSON_PROFILES

6575: x_party_search_rec.JGZZ_FISCAL_CODE
6576: ,x_party_search_rec.PARTY_NUMBER
6577: ,x_party_search_rec.PARTY_TYPE
6578: ,x_party_search_rec.TAX_REFERENCE
6579: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6580: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6581: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6582: AND HZ_PARTIES.party_id = p_party_id;
6583: END IF;

Line 6580: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

6576: ,x_party_search_rec.PARTY_NUMBER
6577: ,x_party_search_rec.PARTY_TYPE
6578: ,x_party_search_rec.TAX_REFERENCE
6579: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6580: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6581: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6582: AND HZ_PARTIES.party_id = p_party_id;
6583: END IF;
6584: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 6581: AND HZ_PERSON_PROFILES.effective_end_date is NULL

6577: ,x_party_search_rec.PARTY_TYPE
6578: ,x_party_search_rec.TAX_REFERENCE
6579: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6580: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6581: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6582: AND HZ_PARTIES.party_id = p_party_id;
6583: END IF;
6584: x_party_search_rec.PARTY_TYPE := l_party_type;
6585: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 6674: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

6670: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
6671: ) IS
6672: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
6673: SELECT org_contact_id
6674: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
6675: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
6676: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6677: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6678: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 6680: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

6676: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6677: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6678: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6679: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6680: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
6681: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
6682:
6683: I NUMBER;
6684: l_org_contact_id NUMBER;

Line 6681: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

6677: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6678: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6679: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6680: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
6681: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
6682:
6683: I NUMBER;
6684: l_org_contact_id NUMBER;
6685: J NUMBER:=1;