APPS.OZF_QP_QUAL_PVT dependencies on HZ_PARTIES

Line 82: AND r1.subject_table_name = 'HZ_PARTIES'

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

Line 84: AND r1.object_table_name = 'HZ_PARTIES'

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

Line 157: AND r1.subject_table_name = 'HZ_PARTIES'

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

Line 159: AND r1.object_table_name = 'HZ_PARTIES'

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

Line 222: AND r1.subject_table_name = 'HZ_PARTIES'

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

Line 224: AND r1.object_table_name = 'HZ_PARTIES'

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

Line 393: FROM hz_parties

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

Line 725: FROM hz_parties

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

Line 1099: FROM hz_parties

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

Line 1431: FROM hz_parties

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