APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 1595: l_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1591: p_error_buffer OUT NOCOPY VARCHAR2) IS
1592:
1593: l_inclusive_tax_flag VARCHAR2(1);
1594: l_reg_party_type zx_lines.registration_party_type%TYPE;
1595: l_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1596: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1597:
1598: CURSOR get_inclusive_flag_from_rate(
1599: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS

Line 1596: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1592:
1593: l_inclusive_tax_flag VARCHAR2(1);
1594: l_reg_party_type zx_lines.registration_party_type%TYPE;
1595: l_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1596: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1597:
1598: CURSOR get_inclusive_flag_from_rate(
1599: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
1600: SELECT inclusive_tax_flag

Line 1605: c_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE) IS

1601: FROM zx_rates_b
1602: WHERE tax_rate_id = c_tax_rate_id;
1603:
1604: CURSOR get_inclusive_flag_from_ptp(
1605: c_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE) IS
1606: SELECT inclusive_tax_flag
1607: FROM zx_party_tax_profile
1608: WHERE party_tax_profile_id = c_ptp_id;
1609:

Line 1607: FROM zx_party_tax_profile

1603:
1604: CURSOR get_inclusive_flag_from_ptp(
1605: c_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE) IS
1606: SELECT inclusive_tax_flag
1607: FROM zx_party_tax_profile
1608: WHERE party_tax_profile_id = c_ptp_id;
1609:
1610: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1611: