eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_34 dependencies on HZ_PERSON_PROFILES

Line 529: FROM HZ_PERSON_PROFILES

525: and effective_end_date is null
526: and rownum = 1;
527: ELSIF l_party_type = 'PERSON' THEN
528: SELECT TAX_NAME INTO l_matched_value
529: FROM HZ_PERSON_PROFILES
530: WHERE party_id = p_record_id
531: and effective_end_date is null
532: and rownum = 1;
533: END IF;

Line 549: FROM HZ_PERSON_PROFILES

545: and effective_end_date is null
546: and rownum = 1;
547: ELSIF l_party_type = 'PERSON' THEN
548: SELECT TAX_REFERENCE INTO l_matched_value
549: FROM HZ_PERSON_PROFILES
550: WHERE party_id = p_record_id
551: and effective_end_date is null
552: and rownum = 1;
553: END IF;

Line 7021: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')

7017: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7018: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7019: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7020: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7021: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7022: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7023: INTO
7024: x_party_search_rec.CATEGORY_CODE
7025: ,x_party_search_rec.PARTY_NUMBER

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

7018: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7019: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7020: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7021: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7022: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7023: INTO
7024: x_party_search_rec.CATEGORY_CODE
7025: ,x_party_search_rec.PARTY_NUMBER
7026: ,x_party_search_rec.PARTY_TYPE

Line 7030: FROM HZ_PARTIES, HZ_PERSON_PROFILES

7026: ,x_party_search_rec.PARTY_TYPE
7027: ,x_party_search_rec.REFERENCE_USE_FLAG
7028: ,x_party_search_rec.TAX_NAME
7029: ,x_party_search_rec.TAX_REFERENCE
7030: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7031: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7032: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7033: AND HZ_PARTIES.party_id = p_party_id;
7034: END IF;

Line 7031: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

7027: ,x_party_search_rec.REFERENCE_USE_FLAG
7028: ,x_party_search_rec.TAX_NAME
7029: ,x_party_search_rec.TAX_REFERENCE
7030: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7031: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7032: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7033: AND HZ_PARTIES.party_id = p_party_id;
7034: END IF;
7035: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 7032: AND HZ_PERSON_PROFILES.effective_end_date is NULL

7028: ,x_party_search_rec.TAX_NAME
7029: ,x_party_search_rec.TAX_REFERENCE
7030: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7031: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7032: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7033: AND HZ_PARTIES.party_id = p_party_id;
7034: END IF;
7035: x_party_search_rec.PARTY_TYPE := l_party_type;
7036: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 7131: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

7127: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
7128: ) IS
7129: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
7130: SELECT org_contact_id
7131: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
7132: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
7133: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7134: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7135: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 7137: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

7133: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7134: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7135: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7136: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7137: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
7138: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
7139:
7140: I NUMBER;
7141: l_org_contact_id NUMBER;

Line 7138: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

7134: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7135: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7136: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7137: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
7138: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
7139:
7140: I NUMBER;
7141: l_org_contact_id NUMBER;
7142: J NUMBER:=1;