APPS.JL_JLBRRINV_XMLP_PKG dependencies on AR_VAT_TAX

Line 114: AR_VAT_TAX ARVT

110: ,0))
111: INTO X_ICMS_TAX_AMOUNT,X_ICMS_TAX_RATE,X_ICMS_TAX_BASE_AMOUNT
112: FROM
113: RA_CUSTOMER_TRX_LINES RACTL,
114: AR_VAT_TAX ARVT
115: WHERE RACTL.LINE_TYPE = 'TAX'
116: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
117: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID
118: AND TO_NUMBER(ARVT.GLOBAL_ATTRIBUTE1) = 2;

Line 141: AR_VAT_TAX ARVT

137: ,0))
138: INTO X_ISS_TAX_AMOUNT
139: FROM
140: RA_CUSTOMER_TRX_LINES RACTL,
141: AR_VAT_TAX ARVT
142: WHERE RACTL.LINE_TYPE = 'TAX'
143: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
144: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID
145: AND TO_NUMBER(ARVT.GLOBAL_ATTRIBUTE1) = 5;

Line 166: AR_VAT_TAX ARVT

162: ,0))
163: INTO X_IRJ_TAX_AMOUNT
164: FROM
165: RA_CUSTOMER_TRX_LINES RACTL,
166: AR_VAT_TAX ARVT
167: WHERE RACTL.LINE_TYPE = 'TAX'
168: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
169: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID
170: AND TO_NUMBER(ARVT.GLOBAL_ATTRIBUTE1) = 4;

Line 196: AR_VAT_TAX ARVT

192: ,0))
193: INTO X_ICMSST_TAX_AMOUNT,X_ICMSST_TAX_BASE_AMOUNT
194: FROM
195: RA_CUSTOMER_TRX_LINES RACTL,
196: AR_VAT_TAX ARVT
197: WHERE RACTL.LINE_TYPE = 'TAX'
198: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
199: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID
200: AND TO_NUMBER(ARVT.GLOBAL_ATTRIBUTE1) = 3;

Line 520: AR_VAT_TAX ARVT

516: ,0))
517: INTO X_IPI_TAX_AMOUNT,X_IPI_TAX_RATE
518: FROM
519: RA_CUSTOMER_TRX_LINES RACTL,
520: AR_VAT_TAX ARVT
521: WHERE RACTL.LINE_TYPE = 'TAX'
522: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
523: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID
524: AND TO_NUMBER(ARVT.GLOBAL_ATTRIBUTE1) = 6;