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.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on HZ_RELATIONSHIPS

Line 1228: hz_relationships hzr

1224: CURSOR get_prim_cont_party_info_reln (p_party_id IN NUMBER) IS
1225: SELECT hzp.person_first_name first_name,
1226: hzp.person_last_name last_name
1227: FROM hz_parties hzp,
1228: hz_relationships hzr
1229: WHERE hzr.PARTY_ID = p_party_id
1230: AND hzr.SUBJECT_ID = hzp.PARTY_ID
1231: AND hzr.SUBJECT_TYPE = 'PERSON';
1232:

Line 1523: -- 2) HZ_RELATIONSHIPS - for contact type = PARTY_RELATIONSHIP

1519: -- At the point of opening this cursor, we already have the contact point id.
1520: -- We use this contact point id to go against the following 2 tables to derive the
1521: -- contact's full name :
1522: -- 1) PER_ALL_PEOPLE_F - for contact type = EMPLOYEE
1523: -- 2) HZ_RELATIONSHIPS - for contact type = PARTY_RELATIONSHIP
1524: -- 3) HZ_PARTIES - for contact type = PERSON
1525:
1526: l_tmp_contact_point_id NUMBER;
1527:

Line 1534: hz_relationships hzr,

1530: hzp.person_last_name last_name,
1531: cshcp.contact_type,
1532: cshcp.contact_point_id
1533: FROM hz_parties hzp,
1534: hz_relationships hzr,
1535: cs_hz_sr_contact_points cshcp
1536: WHERE cshcp.INCIDENT_ID = l_request_id
1537: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1538: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'