APPS.OKC_REP_UTIL_PVT dependencies on HZ_PARTIES

Line 1334: FROM hz_parties

1330: WHERE UPPER(name) = UPPER(p_party_name);
1331:
1332: CURSOR tca_party_exist_csr IS
1333: SELECT party_id
1334: FROM hz_parties
1335: WHERE UPPER(party_name) = UPPER(p_party_name)
1336: AND party_type = 'ORGANIZATION';
1337:
1338: /*CURSOR vendor_exist_csr IS

Line 1346: hz_parties hp

1342:
1343: CURSOR vendor_exist_csr IS
1344: SELECT ap.vendor_id
1345: FROM ap_suppliers ap,
1346: hz_parties hp
1347: WHERE ap.party_id = hp.party_id
1348: AND UPPER(hp.party_name) = UPPER(p_party_name);
1349:
1350: CURSOR rep_party_unique_csr(l_party_role_code2 varchar2) IS

Line 1372: FROM hz_parties

1368: AND organization_id = p_party_id;
1369:
1370: CURSOR tca_party_and_role_csr IS
1371: SELECT 1
1372: FROM hz_parties
1373: WHERE UPPER(party_name) = UPPER(p_party_name)
1374: AND party_id = p_party_id;
1375:
1376: /*CURSOR vendor_and_role_csr IS

Line 1385: hz_parties hp

1381:
1382: CURSOR vendor_and_role_csr IS
1383: SELECT 1
1384: FROM ap_suppliers ap,
1385: hz_parties hp
1386: WHERE UPPER(hp.party_name) = UPPER(p_party_name)
1387: AND hp.party_id = ap.party_id
1388: AND ap.vendor_id = p_party_id;
1389:

Line 1810: 'Party with id' || p_party_id || ' and name ' || p_party_name || 'not found in table HZ_PARTIES');

1806: IF tca_party_and_role_csr%NOTFOUND THEN
1807:
1808: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1809: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1810: 'Party with id' || p_party_id || ' and name ' || p_party_name || 'not found in table HZ_PARTIES');
1811: END IF;
1812:
1813: CLOSE tca_party_and_role_csr;
1814:

Line 2205: hz_parties hz,

2201:
2202: CURSOR tca_party_contact_csr IS
2203: SELECT 1
2204: FROM hz_relationships hr,
2205: hz_parties hz,
2206: hz_parties hz1
2207: WHERE hr.party_id = p_contact_id
2208: AND hr.subject_type = 'PERSON'
2209: AND hr.object_type = 'ORGANIZATION'

Line 2206: hz_parties hz1

2202: CURSOR tca_party_contact_csr IS
2203: SELECT 1
2204: FROM hz_relationships hr,
2205: hz_parties hz,
2206: hz_parties hz1
2207: WHERE hr.party_id = p_contact_id
2208: AND hr.subject_type = 'PERSON'
2209: AND hr.object_type = 'ORGANIZATION'
2210: AND hr.object_table_name = 'HZ_PARTIES'

Line 2210: AND hr.object_table_name = 'HZ_PARTIES'

2206: hz_parties hz1
2207: WHERE hr.party_id = p_contact_id
2208: AND hr.subject_type = 'PERSON'
2209: AND hr.object_type = 'ORGANIZATION'
2210: AND hr.object_table_name = 'HZ_PARTIES'
2211: AND hr.object_id = p_party_id
2212: AND hr.relationship_code = 'CONTACT_OF'
2213: AND hz.party_id = p_contact_id
2214: AND hz1.party_id = hr.subject_id

Line 6326: AND cp.owner_table_name='HZ_PARTIES'

6322: CURSOR tca_email_csr(l_contact_id NUMBER) IS
6323: SELECT email_address
6324: FROM hz_contact_points cp
6325: WHERE cp.owner_table_id = l_contact_id
6326: AND cp.owner_table_name='HZ_PARTIES'
6327: AND cp.contact_point_type = 'EMAIL';
6328: BEGIN
6329: l_api_name := 'get_customer_userlist';
6330: