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_42 dependencies on HZ_PERSON_PROFILES

Line 497: FROM HZ_PERSON_PROFILES

493: and effective_end_date is null
494: and rownum = 1;
495: ELSIF l_party_type = 'PERSON' THEN
496: SELECT TAX_NAME INTO l_matched_value
497: FROM HZ_PERSON_PROFILES
498: WHERE party_id = p_record_id
499: and effective_end_date is null
500: and rownum = 1;
501: END IF;

Line 517: FROM HZ_PERSON_PROFILES

513: and effective_end_date is null
514: and rownum = 1;
515: ELSIF l_party_type = 'PERSON' THEN
516: SELECT TAX_REFERENCE INTO l_matched_value
517: FROM HZ_PERSON_PROFILES
518: WHERE party_id = p_record_id
519: and effective_end_date is null
520: and rownum = 1;
521: END IF;

Line 537: FROM HZ_PERSON_PROFILES

533: and effective_end_date is null
534: and rownum = 1;
535: ELSIF l_party_type = 'PERSON' THEN
536: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
537: FROM HZ_PERSON_PROFILES
538: WHERE party_id = p_record_id
539: and effective_end_date is null
540: and rownum = 1;
541: END IF;

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

7019: AND HZ_PARTIES.party_id = p_party_id;
7020: ELSIF l_party_type = 'PERSON' THEN
7021: SELECT
7022: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7023: ,translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
7024: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
7025: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7026: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7027: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')

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

7023: ,translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
7024: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
7025: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7026: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7027: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7028: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7029: INTO
7030: x_party_search_rec.CATEGORY_CODE
7031: ,x_party_search_rec.JGZZ_FISCAL_CODE

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

7024: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
7025: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7026: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7027: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7028: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7029: INTO
7030: x_party_search_rec.CATEGORY_CODE
7031: ,x_party_search_rec.JGZZ_FISCAL_CODE
7032: ,x_party_search_rec.PARTY_NAME

Line 7037: FROM HZ_PARTIES, HZ_PERSON_PROFILES

7033: ,x_party_search_rec.PARTY_TYPE
7034: ,x_party_search_rec.REFERENCE_USE_FLAG
7035: ,x_party_search_rec.TAX_NAME
7036: ,x_party_search_rec.TAX_REFERENCE
7037: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7038: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7039: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7040: AND HZ_PARTIES.party_id = p_party_id;
7041: END IF;

Line 7038: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

7034: ,x_party_search_rec.REFERENCE_USE_FLAG
7035: ,x_party_search_rec.TAX_NAME
7036: ,x_party_search_rec.TAX_REFERENCE
7037: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7038: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7039: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7040: AND HZ_PARTIES.party_id = p_party_id;
7041: END IF;
7042: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 7039: AND HZ_PERSON_PROFILES.effective_end_date is NULL

7035: ,x_party_search_rec.TAX_NAME
7036: ,x_party_search_rec.TAX_REFERENCE
7037: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7038: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7039: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7040: AND HZ_PARTIES.party_id = p_party_id;
7041: END IF;
7042: x_party_search_rec.PARTY_TYPE := l_party_type;
7043: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 7138: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

7134: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
7135: ) IS
7136: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
7137: SELECT org_contact_id
7138: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
7139: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
7140: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7141: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7142: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 7144: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

7140: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7141: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7142: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7143: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7144: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
7145: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
7146:
7147: I NUMBER;
7148: l_org_contact_id NUMBER;

Line 7145: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

7141: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7142: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7143: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7144: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
7145: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
7146:
7147: I NUMBER;
7148: l_org_contact_id NUMBER;
7149: J NUMBER:=1;