DBA Data[Home] [Help]

APPS.JA_JAINRG1_XMLP_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 430: JAI_AR_TRX_TAX_LINES JRCTTL,

426: SELECT
427: JRCTTL.TAX_RATE CESS_RATE
428: FROM
429: JAI_AR_TRX_LINES JRCTL,
430: JAI_AR_TRX_TAX_LINES JRCTTL,
431: JAI_CMN_TAXES_ALL JTC
432: WHERE JRCTL.CUSTOMER_TRX_LINE_ID = JRCTTL.LINK_TO_CUST_TRX_LINE_ID
433: AND JRCTTL.TAX_ID = JTC.TAX_ID
434: AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_EDUCATION_CESS' , 'CVD_EDUCATION_CESS' )

Line 520: JAI_AR_TRX_TAX_LINES JRCTTL,

516: SELECT
517: JRCTTL.TAX_RATE CESS_RATE
518: FROM
519: JAI_AR_TRX_LINES JRCTL,
520: JAI_AR_TRX_TAX_LINES JRCTTL,
521: JAI_CMN_TAXES_ALL JTC
522: WHERE JRCTL.CUSTOMER_TRX_LINE_ID = JRCTTL.LINK_TO_CUST_TRX_LINE_ID
523: AND JRCTTL.TAX_ID = JTC.TAX_ID
524: AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' )