APPS.ZX_TPI_SERVICES_PKG dependencies on HZ_PARTIES

Line 1243: FROM HZ_PARTIES pty,

1239: IF x_provider_id <> 0 THEN
1240: BEGIN
1241: SELECT party_name
1242: INTO l_provider_name
1243: FROM HZ_PARTIES pty,
1244: ZX_PARTY_TAX_PROFILE ptp
1245: WHERE pty.party_id = ptp.party_id
1246: AND ptp.party_tax_profile_id = x_provider_id;
1247: EXCEPTION

Line 1320: FROM hz_parties pty,

1316:
1317: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1318: SELECT party_name
1319: INTO l_provider_name
1320: FROM hz_parties pty,
1321: zx_party_tax_profile ptp
1322: WHERE pty.party_id = ptp.party_id
1323: AND ptp.party_tax_profile_id = x_provider_id;
1324:

Line 1722: HZ_PARTIES pty

1718: INTO l_legal_entity_number,
1719: l_establishment_name
1720: FROM XLE_ETB_PROFILES xletb,
1721: XLE_ENTITY_PROFILES xlent,
1722: HZ_PARTIES pty
1723: WHERE xletb.establishment_id = p_event_class_rec.establishment_id
1724: AND xlent.legal_entity_id = xletb.legal_entity_id
1725: AND pty.party_id = xlent.party_id
1726: AND xletb.main_establishment_flag = 'Y';

Line 1743: FROM HZ_PARTIES pty,

1739: SELECT pty.party_number
1740: , pty.party_id
1741: INTO l_establishment_number
1742: , l_party_id
1743: FROM HZ_PARTIES pty,
1744: ZX_PARTY_TAX_PROFILE ptp
1745: WHERE ptp.party_tax_profile_id = l_hq_estb_ptp_id
1746: AND pty.party_id = ptp.party_id;
1747: EXCEPTION WHEN OTHERS THEN

Line 1754: HZ_PARTIES pty,

1750: BEGIN
1751: SELECT pty.party_number
1752: INTO l_legal_entity_number
1753: FROM XLE_ETB_PROFILES xletb,
1754: HZ_PARTIES pty,
1755: XLE_ENTITY_PROFILES xep
1756: WHERE xletb.party_id = l_party_id
1757: AND xletb.legal_entity_id = xep.legal_entity_id
1758: AND pty.party_id = xep.party_id;