DBA Data[Home] [Help]

APPS.JAI_AR_TRX_PKG dependencies on STANDARD

Line 75: AND zrb.tax_status_code = 'STANDARD'

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'
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:

Line 86: AND zrb.tax_status_code = 'STANDARD'

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'
88: AND trunc(sysdate) between trunc(zrb.effective_from) and trunc(nvl(zrb.effective_to, sysdate)) ;
89:
90: /*------------------------------------------------------------------------------------