APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on ZX_PARTY_TAX_PROFILE

Line 4704: FROM zx_party_tax_profile ptp,

4700: -- Added following cursor for Bug Fix 5163401
4701:
4702: CURSOR c_get_le_ptp_id(c_le_id NUMBER) IS
4703: SELECT ptp.party_tax_profile_id
4704: FROM zx_party_tax_profile ptp,
4705: xle_entity_profiles le
4706: WHERE ptp.party_type_code = 'FIRST_PARTY'
4707: AND ptp.party_id = le.party_id
4708: AND le.legal_entity_id = c_le_id;

Line 5804: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;

5800: p_error_buffer OUT NOCOPY VARCHAR2)
5801: IS
5802: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
5803: l_first_party_flag BOOLEAN;
5804: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5805: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
5806: l_ret_record_level VARCHAR2(30);
5807:
5808: BEGIN

Line 6352: -- zx_party_tax_profile

6348: -- get_party_tax_info
6349: --
6350: -- DESCRIPTION
6351: -- This procedure returns the tax classification code obtained from
6352: -- zx_party_tax_profile
6353:
6354: PROCEDURE get_party_tax_info(
6355: p_structure_name IN VARCHAR2,
6356: p_structure_index IN BINARY_INTEGER,

Line 6364: l_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

6360: p_return_status OUT NOCOPY VARCHAR2,
6361: p_error_buffer OUT NOCOPY VARCHAR2)
6362:
6363: IS
6364: l_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
6365:
6366: CURSOR get_tax_classification_csr
6367: (c_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE)
6368: IS

Line 6367: (c_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE)

6363: IS
6364: l_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
6365:
6366: CURSOR get_tax_classification_csr
6367: (c_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE)
6368: IS
6369: SELECT Tax_Classification_Code
6370: FROM ZX_PARTY_TAX_PROFILE
6371: WHERE PARTY_TAX_PROFILE_ID = c_party_tax_profile_id;

Line 6370: FROM ZX_PARTY_TAX_PROFILE

6366: CURSOR get_tax_classification_csr
6367: (c_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE)
6368: IS
6369: SELECT Tax_Classification_Code
6370: FROM ZX_PARTY_TAX_PROFILE
6371: WHERE PARTY_TAX_PROFILE_ID = c_party_tax_profile_id;
6372:
6373: BEGIN
6374: