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

Line 316: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

312: IF p_attribute = 'JOB_TITLE' THEN
313: BEGIN
314: SELECT HZ_ORG_CONTACTS.JOB_TITLE
315: INTO l_matched_value
316: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
317: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
318: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
319: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
320: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 322: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

318: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
319: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
320: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
321: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
322: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
323: AND HZ_PERSON_PROFILES.effective_end_date IS NULL and rownum=1;
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN
326: l_matched_value := 'Err';

Line 323: AND HZ_PERSON_PROFILES.effective_end_date IS NULL and rownum=1;

319: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
320: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
321: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
322: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
323: AND HZ_PERSON_PROFILES.effective_end_date IS NULL and rownum=1;
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN
326: l_matched_value := 'Err';
327: END;

Line 5617: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5613: ) IS
5614: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5615: SELECT org_contact_id
5616: ,translate(HZ_ORG_CONTACTS.JOB_TITLE, '%',' ')
5617: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5618: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5619: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5620: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5621: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5623: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5619: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5620: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5621: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5622: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5623: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5624: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5625:
5626: I NUMBER;
5627: l_org_contact_id NUMBER;

Line 5624: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

5620: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5621: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5622: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5623: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5624: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5625:
5626: I NUMBER;
5627: l_org_contact_id NUMBER;
5628: J NUMBER:=1;