APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 1373: ZX_PARTY_TAX_PROFILE ptp

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
1377: WHEN OTHERS THEN

Line 1450: zx_party_tax_profile ptp

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:
1454: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 1516: FROM zx_party_tax_profile ptp,

1512: l_service_provider VARCHAR2(360);
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;

Line 1749: l_party_id ZX_PARTY_TAX_PROFILE.party_id%type; -- Bug 5090593

1745: l_application_short_name FND_APPLICATION.application_short_name%type;
1746: -- Bug# 4769082
1747: l_cnt_of_options_gt NUMBER;
1748: l_hq_estb_ptp_id ZX_LINES_DET_FACTORS.hq_estb_party_tax_prof_id%type; -- Bug 5090593
1749: l_party_id ZX_PARTY_TAX_PROFILE.party_id%type; -- Bug 5090593
1750: l_tax_provider_id NUMBER; -- Bug 5090593
1751:
1752: BEGIN
1753: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1905: ZX_PARTY_TAX_PROFILE ptp

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
1909: l_establishment_number := NULL;