APPS.ZX_TPI_SERVICES_PKG dependencies on HZ_PARTIES

Line 1372: FROM HZ_PARTIES pty,

1368: IF x_provider_id <> 0 THEN
1369: BEGIN
1370: SELECT party_name
1371: INTO l_provider_name
1372: FROM HZ_PARTIES pty,
1373: ZX_PARTY_TAX_PROFILE ptp
1374: WHERE pty.party_id = ptp.party_id
1375: AND ptp.party_tax_profile_id = x_provider_id;
1376: EXCEPTION

Line 1449: FROM hz_parties pty,

1445:
1446: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1447: SELECT party_name
1448: INTO l_provider_name
1449: FROM hz_parties pty,
1450: zx_party_tax_profile ptp
1451: WHERE pty.party_id = ptp.party_id
1452: AND ptp.party_tax_profile_id = x_provider_id;
1453:

Line 1517: hz_parties pty

1513:
1514: CURSOR get_service_provider_csr (c_provider_id NUMBER) IS
1515: SELECT pty.party_name
1516: FROM zx_party_tax_profile ptp,
1517: hz_parties pty
1518: WHERE ptp.party_tax_profile_id = p_provider_id
1519: AND ptp.party_id = pty.party_id
1520: AND rownum = 1;
1521:

Line 1883: HZ_PARTIES pty

1879: INTO l_legal_entity_number,
1880: l_establishment_name
1881: FROM XLE_ETB_PROFILES xletb,
1882: XLE_ENTITY_PROFILES xlent,
1883: HZ_PARTIES pty
1884: WHERE xletb.establishment_id = p_event_class_rec.establishment_id
1885: AND xlent.legal_entity_id = xletb.legal_entity_id
1886: AND pty.party_id = xlent.party_id
1887: AND xletb.main_establishment_flag = 'Y';

Line 1904: FROM HZ_PARTIES pty,

1900: SELECT pty.party_number
1901: , pty.party_id
1902: INTO l_establishment_number
1903: , l_party_id
1904: FROM HZ_PARTIES pty,
1905: ZX_PARTY_TAX_PROFILE ptp
1906: WHERE ptp.party_tax_profile_id = l_hq_estb_ptp_id
1907: AND pty.party_id = ptp.party_id;
1908: EXCEPTION WHEN OTHERS THEN

Line 1915: HZ_PARTIES pty,

1911: BEGIN
1912: SELECT pty.party_number
1913: INTO l_legal_entity_number
1914: FROM XLE_ETB_PROFILES xletb,
1915: HZ_PARTIES pty,
1916: XLE_ENTITY_PROFILES xep
1917: WHERE xletb.party_id = l_party_id
1918: AND xletb.legal_entity_id = xep.legal_entity_id
1919: AND pty.party_id = xep.party_id;