APPS.JA_JAINSITR_XMLP_PKG dependencies on JAI_AR_SUP_TAXES

Line 16: JAI_AR_SUP_TAXES A,

12: CURSOR EXCISE(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
13: SELECT
14: SUM(DIFF_AMT) EXCISE
15: FROM
16: JAI_AR_SUP_TAXES A,
17: JAI_AR_SUP_LINES B,
18: JAI_AR_SUP_HDRS_ALL C
19: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
20: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE

Line 51: JAI_AR_SUP_TAXES A,

47: CURSOR SALES(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
48: SELECT
49: SUM(DIFF_AMT) SALES
50: FROM
51: JAI_AR_SUP_TAXES A,
52: JAI_AR_SUP_LINES B,
53: JAI_AR_SUP_HDRS_ALL C
54: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
55: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE

Line 86: JAI_AR_SUP_TAXES A,

82: CURSOR CST(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
83: SELECT
84: SUM(DIFF_AMT) EXCISE
85: FROM
86: JAI_AR_SUP_TAXES A,
87: JAI_AR_SUP_LINES B,
88: JAI_AR_SUP_HDRS_ALL C
89: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
90: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE

Line 124: JAI_AR_SUP_TAXES A,

120: CURSOR OTHERS IS
121: SELECT
122: SUM(DIFF_AMT) OTHER
123: FROM
124: JAI_AR_SUP_TAXES A,
125: JAI_AR_SUP_LINES B,
126: JAI_AR_SUP_HDRS_ALL C
127: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
128: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE