APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on ZX_PARTY_TAX_PROFILE

Line 5048: FROM zx_party_tax_profile ptp,

5044: -- Added following cursor for Bug Fix 5163401
5045:
5046: CURSOR c_get_le_ptp_id(c_le_id NUMBER) IS
5047: SELECT ptp.party_tax_profile_id
5048: FROM zx_party_tax_profile ptp,
5049: xle_entity_profiles le
5050: WHERE ptp.party_type_code = 'FIRST_PARTY'
5051: AND ptp.party_id = le.party_id
5052: AND le.legal_entity_id = c_le_id;

Line 6255: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;

6251: p_error_buffer OUT NOCOPY VARCHAR2)
6252: IS
6253: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
6254: l_first_party_flag BOOLEAN;
6255: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;
6256: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
6257: l_ret_record_level VARCHAR2(30);
6258:
6259: BEGIN

Line 6803: -- zx_party_tax_profile

6799: -- get_party_tax_info
6800: --
6801: -- DESCRIPTION
6802: -- This procedure returns the tax classification code obtained from
6803: -- zx_party_tax_profile
6804:
6805: PROCEDURE get_party_tax_info(
6806: p_structure_name IN VARCHAR2,
6807: p_structure_index IN BINARY_INTEGER,

Line 6815: l_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

6811: p_return_status OUT NOCOPY VARCHAR2,
6812: p_error_buffer OUT NOCOPY VARCHAR2)
6813:
6814: IS
6815: l_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
6816:
6817: CURSOR get_tax_classification_csr
6818: (c_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE)
6819: IS

Line 6818: (c_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE)

6814: IS
6815: l_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
6816:
6817: CURSOR get_tax_classification_csr
6818: (c_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE)
6819: IS
6820: SELECT Tax_Classification_Code
6821: FROM ZX_PARTY_TAX_PROFILE
6822: WHERE PARTY_TAX_PROFILE_ID = c_party_tax_profile_id;

Line 6821: FROM ZX_PARTY_TAX_PROFILE

6817: CURSOR get_tax_classification_csr
6818: (c_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE)
6819: IS
6820: SELECT Tax_Classification_Code
6821: FROM ZX_PARTY_TAX_PROFILE
6822: WHERE PARTY_TAX_PROFILE_ID = c_party_tax_profile_id;
6823:
6824: BEGIN
6825: