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 501: FROM HZ_PERSON_PROFILES

497: and effective_end_date is null
498: and rownum = 1;
499: ELSIF l_party_type = 'PERSON' THEN
500: SELECT TAX_NAME INTO l_matched_value
501: FROM HZ_PERSON_PROFILES
502: WHERE party_id = p_record_id
503: and effective_end_date is null
504: and rownum = 1;
505: END IF;

Line 521: FROM HZ_PERSON_PROFILES

517: and effective_end_date is null
518: and rownum = 1;
519: ELSIF l_party_type = 'PERSON' THEN
520: SELECT TAX_REFERENCE INTO l_matched_value
521: FROM HZ_PERSON_PROFILES
522: WHERE party_id = p_record_id
523: and effective_end_date is null
524: and rownum = 1;
525: END IF;

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

7006: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7007: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7008: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7009: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7010: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7011: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7012: INTO
7013: x_party_search_rec.CATEGORY_CODE
7014: ,x_party_search_rec.PARTY_NUMBER

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

7007: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7008: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7009: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7010: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7011: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7012: INTO
7013: x_party_search_rec.CATEGORY_CODE
7014: ,x_party_search_rec.PARTY_NUMBER
7015: ,x_party_search_rec.PARTY_TYPE

Line 7019: FROM HZ_PARTIES, HZ_PERSON_PROFILES

7015: ,x_party_search_rec.PARTY_TYPE
7016: ,x_party_search_rec.REFERENCE_USE_FLAG
7017: ,x_party_search_rec.TAX_NAME
7018: ,x_party_search_rec.TAX_REFERENCE
7019: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7020: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7021: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7022: AND HZ_PARTIES.party_id = p_party_id;
7023: END IF;

Line 7020: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

7016: ,x_party_search_rec.REFERENCE_USE_FLAG
7017: ,x_party_search_rec.TAX_NAME
7018: ,x_party_search_rec.TAX_REFERENCE
7019: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7020: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7021: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7022: AND HZ_PARTIES.party_id = p_party_id;
7023: END IF;
7024: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 7021: AND HZ_PERSON_PROFILES.effective_end_date is NULL

7017: ,x_party_search_rec.TAX_NAME
7018: ,x_party_search_rec.TAX_REFERENCE
7019: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7020: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7021: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7022: AND HZ_PARTIES.party_id = p_party_id;
7023: END IF;
7024: x_party_search_rec.PARTY_TYPE := l_party_type;
7025: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 7120: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

7116: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
7117: ) IS
7118: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
7119: SELECT org_contact_id
7120: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
7121: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
7122: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7123: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7124: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 7126: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

7122: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7123: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7124: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7125: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7126: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
7127: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
7128:
7129: I NUMBER;
7130: l_org_contact_id NUMBER;

Line 7127: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

7123: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7124: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7125: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7126: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
7127: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
7128:
7129: I NUMBER;
7130: l_org_contact_id NUMBER;
7131: J NUMBER:=1;