APPS.AST_UWQ_WRAPPER_PKG dependencies on HZ_RELATIONSHIPS

Line 203: FROM hz_relationships

199: WHERE user_id = x_user_id;
200:
201: CURSOR C_subject_and_object(x_party_id NUMBER) IS
202: SELECT subject_id, object_id
203: FROM hz_relationships
204: WHERE party_id = x_party_id
205: AND directional_flag = 'F'
206: AND status = 'A';
207:

Line 556: FROM hz_relationships

552: WHERE delinquency_id = p_delinquency_id;
553:
554: CURSOR C_subject_and_object(p_party_id NUMBER) IS
555: SELECT subject_id, object_id
556: FROM hz_relationships
557: WHERE party_id = p_party_id
558: AND directional_flag = 'F'
559: AND status = 'A';
560:

Line 1092: FROM hz_relationships r,

1088:
1089:
1090: CURSOR c_get_org_contact_id(X_PARTY_ID NUMBER) IS
1091: SELECT o.org_contact_id
1092: FROM hz_relationships r,
1093: hz_org_contacts o
1094: WHERE o.party_relationship_id = r.relationship_id
1095: AND r.party_id = X_PARTY_ID
1096: AND r.directional_flag = 'F';