APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 1368: l_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1364: p_error_buffer OUT NOCOPY VARCHAR2) IS
1365:
1366: l_inclusive_tax_flag VARCHAR2(1);
1367: l_reg_party_type zx_lines.registration_party_type%TYPE;
1368: l_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1369: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1370:
1371: CURSOR get_inclusive_flag_from_rate(
1372: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS

Line 1369: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1365:
1366: l_inclusive_tax_flag VARCHAR2(1);
1367: l_reg_party_type zx_lines.registration_party_type%TYPE;
1368: l_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1369: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1370:
1371: CURSOR get_inclusive_flag_from_rate(
1372: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
1373: SELECT inclusive_tax_flag

Line 1378: c_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE) IS

1374: FROM zx_rates_b
1375: WHERE tax_rate_id = c_tax_rate_id;
1376:
1377: CURSOR get_inclusive_flag_from_ptp(
1378: c_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE) IS
1379: SELECT inclusive_tax_flag
1380: FROM zx_party_tax_profile
1381: WHERE party_tax_profile_id = c_ptp_id;
1382: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

Line 1380: FROM zx_party_tax_profile

1376:
1377: CURSOR get_inclusive_flag_from_ptp(
1378: c_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE) IS
1379: SELECT inclusive_tax_flag
1380: FROM zx_party_tax_profile
1381: WHERE party_tax_profile_id = c_ptp_id;
1382: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1383:
1384: BEGIN