eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_TRX_PKG dependencies on ZX_RATES_B

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

Line 72: FROM zx_rates_b zrb

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
75: AND zrb.tax_status_code = 'STANDARD'
76: AND zrb.active_flag = 'Y'

Line 81: CURSOR c_max_tax_rate_id_cur (cp_tax_regime_code zx_rates_b.tax_regime_code%type) IS

77: AND zrb.content_owner_id = cp_party_tax_profile_id
78: AND trunc(sysdate) between trunc(zrb.effective_from) and trunc(nvl(zrb.effective_to, sysdate)) ;
79:
80: --Get the max(tax_rate_id)
81: CURSOR c_max_tax_rate_id_cur (cp_tax_regime_code zx_rates_b.tax_regime_code%type) IS
82: SELECT max(tax_rate_id)
83: FROM zx_rates_b zrb
84: WHERE zrb.tax = 'LOCALIZATION' -- 'Localization' , Harshita for Bug 4907217
85: AND zrb.tax_regime_code = cp_tax_regime_code

Line 83: FROM zx_rates_b zrb

79:
80: --Get the max(tax_rate_id)
81: CURSOR c_max_tax_rate_id_cur (cp_tax_regime_code zx_rates_b.tax_regime_code%type) IS
82: SELECT max(tax_rate_id)
83: FROM zx_rates_b zrb
84: WHERE zrb.tax = 'LOCALIZATION' -- 'Localization' , Harshita for Bug 4907217
85: AND zrb.tax_regime_code = cp_tax_regime_code
86: AND zrb.tax_status_code = 'STANDARD'
87: AND zrb.active_flag = 'Y'