APPS.OZF_QP_QUAL_PVT dependencies on HZ_RELATIONSHIPS

Line 82: FROM hz_relationships r1

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

Line 157: FROM hz_relationships r1

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

Line 222: FROM hz_relationships r1

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