APPS.OZF_QP_QUAL_PVT dependencies on HZ_PARTIES

Line 85: AND r1.subject_table_name = 'HZ_PARTIES'

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'
87: AND r1.object_table_name = 'HZ_PARTIES'
88: AND r1.start_date <= SYSDATE AND NVL(r1.end_date, SYSDATE) >= SYSDATE
89: AND r1.status = 'A'

Line 87: AND r1.object_table_name = 'HZ_PARTIES'

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'
87: AND r1.object_table_name = 'HZ_PARTIES'
88: AND r1.start_date <= SYSDATE AND NVL(r1.end_date, SYSDATE) >= SYSDATE
89: AND r1.status = 'A'
90: AND r1.subject_id=p_party_id;
91:

Line 160: AND r1.subject_table_name = 'HZ_PARTIES'

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'
162: AND r1.object_table_name = 'HZ_PARTIES'
163: AND r1.start_date <= SYSDATE AND NVL(r1.end_date, SYSDATE) >= SYSDATE
164: AND r1.status = 'A'

Line 162: AND r1.object_table_name = 'HZ_PARTIES'

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'
162: AND r1.object_table_name = 'HZ_PARTIES'
163: AND r1.start_date <= SYSDATE AND NVL(r1.end_date, SYSDATE) >= SYSDATE
164: AND r1.status = 'A'
165: AND r1.subject_id=p_party_id;
166:

Line 225: AND r1.subject_table_name = 'HZ_PARTIES'

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'
227: AND r1.object_table_name = 'HZ_PARTIES'
228: AND r1.start_date <= SYSDATE AND NVL(r1.end_date, SYSDATE) >= SYSDATE
229: AND r1.status = 'A'

Line 227: AND r1.object_table_name = 'HZ_PARTIES'

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'
227: AND r1.object_table_name = 'HZ_PARTIES'
228: AND r1.start_date <= SYSDATE AND NVL(r1.end_date, SYSDATE) >= SYSDATE
229: AND r1.status = 'A'
230: AND r1.subject_id=p_party_id;
231:

Line 396: FROM hz_parties

392: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
393:
394: CURSOR cur_get_party_info(p_party_id NUMBER) IS
395: SELECT city,postal_code,state,county,country,party_id
396: FROM hz_parties
397: WHERE party_id = p_party_id;
398:
399: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
400: SELECT party_id

Line 728: FROM hz_parties

724: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
725:
726: CURSOR cur_get_party_info(p_party_id NUMBER) IS
727: SELECT city,postal_code,state,county,country,party_id,province,category_code
728: FROM hz_parties
729: WHERE party_id = p_party_id;
730:
731: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
732: SELECT party_id

Line 1102: FROM hz_parties

1098: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1099:
1100: CURSOR cur_get_party_info(p_party_id NUMBER) IS
1101: SELECT city,postal_code,state,county,country,party_id
1102: FROM hz_parties
1103: WHERE party_id = p_party_id;
1104:
1105: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
1106: SELECT party_id

Line 1434: FROM hz_parties

1430: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1431:
1432: CURSOR cur_get_party_info(p_party_id NUMBER) IS
1433: SELECT city,postal_code,state,county,country,party_id
1434: FROM hz_parties
1435: WHERE party_id = p_party_id;
1436:
1437: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
1438: SELECT party_id