APPS.PRP_IH_EMAIL_PVT dependencies on HZ_RELATIONSHIPS

Line 80: HZ_RELATIONSHIPS HPR

76:
77: CURSOR c_party_person(l_party_id NUMBER) IS
78: SELECT HPR.PARTY_ID
79: FROM HZ_PARTIES HZP,
80: HZ_RELATIONSHIPS HPR
81: WHERE HZP.PARTY_ID = HPR.PARTY_ID
82: AND HPR.SUBJECT_ID = l_party_id;
83:
84: CURSOR c_party_rel(l_party_id NUMBER, l_object_id NUMBER) IS

Line 87: HZ_RELATIONSHIPS HPR

83:
84: CURSOR c_party_rel(l_party_id NUMBER, l_object_id NUMBER) IS
85: SELECT HPR.SUBJECT_ID
86: FROM HZ_PARTIES HZP,
87: HZ_RELATIONSHIPS HPR
88: WHERE HZP.PARTY_ID = HPR.SUBJECT_ID
89: AND HPR.PARTY_ID = l_party_id
90: AND HPR.OBJECT_ID = l_object_id;
91: