APPS.OZF_QP_QUAL_PVT dependencies on HZ_RELATIONSHIPS

Line 79: FROM hz_relationships r1

75: */
76:
77: CURSOR c_bg IS
78: SELECT r1.object_id
79: FROM hz_relationships r1
80: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
81: AND r1.subject_type = 'ORGANIZATION'
82: AND r1.subject_table_name = 'HZ_PARTIES'
83: AND r1.object_type = 'ORGANIZATION'

Line 154: FROM hz_relationships r1

150: */
151:
152: CURSOR c_bg IS
153: SELECT r1.object_id
154: FROM hz_relationships r1
155: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
156: AND r1.subject_type = 'ORGANIZATION'
157: AND r1.subject_table_name = 'HZ_PARTIES'
158: AND r1.object_type = 'ORGANIZATION'

Line 219: FROM hz_relationships r1

215: WHERE cust_account_id = p_sold_to_org;
216:
217: CURSOR c_bg IS
218: SELECT r1.object_id
219: FROM hz_relationships r1
220: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
221: AND r1.subject_type = 'ORGANIZATION'
222: AND r1.subject_table_name = 'HZ_PARTIES'
223: AND r1.object_type = 'ORGANIZATION'