APPS.JAI_AR_TRX_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 65: FROM zx_party_tax_profile zptp

61:
62: --Get the party_tax_profile_id
63: CURSOR c_party_tax_profile_id_cur(p_org_id IN NUMBER) IS
64: SELECT party_tax_profile_id
65: FROM zx_party_tax_profile zptp
66: WHERE party_id = p_org_id
67: and party_type_code = 'OU';
68:
69: --Get the tax_rate_id

Line 70: CURSOR c_tax_rate_id_cur (cp_tax_regime_code zx_rates_b.tax_regime_code%type, cp_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type) IS

66: WHERE party_id = p_org_id
67: and party_type_code = 'OU';
68:
69: --Get the tax_rate_id
70: CURSOR c_tax_rate_id_cur (cp_tax_regime_code zx_rates_b.tax_regime_code%type, cp_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type) IS
71: SELECT tax_rate_id
72: FROM zx_rates_b zrb
73: WHERE zrb.tax = 'LOCALIZATION' -- 'Localization' , Harshita for Bug 4907217
74: AND zrb.tax_regime_code = cp_tax_regime_code