APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 1244: ZX_PARTY_TAX_PROFILE ptp

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

Line 1321: zx_party_tax_profile ptp

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

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

1595: l_application_short_name FND_APPLICATION.application_short_name%type;
1596: -- Bug# 4769082
1597: l_cnt_of_options_gt NUMBER;
1598: l_hq_estb_ptp_id ZX_LINES_DET_FACTORS.hq_estb_party_tax_prof_id%type; -- Bug 5090593
1599: l_party_id ZX_PARTY_TAX_PROFILE.party_id%type; -- Bug 5090593
1600: l_tax_provider_id NUMBER; -- Bug 5090593
1601:
1602: BEGIN
1603: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1744: ZX_PARTY_TAX_PROFILE ptp

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