APPS.JA_JAINSTPR_XMLP_PKG dependencies on JAI_CMN_TAXES_ALL

Line 12: CURSOR EXCISE(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

8: END SERIAL_FFORMULA;
9:
10: FUNCTION EXCISE_TAXFORMULA(CUSTOMER_TRX_ID IN NUMBER
11: ,SUPP_INV_TYPE IN VARCHAR2) RETURN NUMBER IS
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,

Line 29: JAI_CMN_TAXES_ALL D

25: AND EXISTS (
26: SELECT
27: 1
28: FROM
29: JAI_CMN_TAXES_ALL D
30: WHERE TAX_TYPE LIKE CP_TAX_TYPE
31: AND D.TAX_ID = A.NEW_TAX_ID )
32: GROUP BY
33: C.CUSTOMER_TRX_ID,

Line 47: CURSOR SALES(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

43: END EXCISE_TAXFORMULA;
44:
45: FUNCTION CF_5FORMULA(CUSTOMER_TRX_ID IN NUMBER
46: ,SUPP_INV_TYPE IN VARCHAR2) RETURN NUMBER IS
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,

Line 64: JAI_CMN_TAXES_ALL D

60: AND EXISTS (
61: SELECT
62: 1
63: FROM
64: JAI_CMN_TAXES_ALL D
65: WHERE TAX_TYPE LIKE CP_TAX_TYPE
66: AND D.TAX_ID = A.NEW_TAX_ID )
67: GROUP BY
68: C.CUSTOMER_TRX_ID,

Line 82: CURSOR CST(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

78: END CF_5FORMULA;
79:
80: FUNCTION CSTFORMULA(CUSTOMER_TRX_ID IN NUMBER
81: ,SUPP_INV_TYPE IN VARCHAR2) RETURN NUMBER IS
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,

Line 99: JAI_CMN_TAXES_ALL D

95: AND EXISTS (
96: SELECT
97: 1
98: FROM
99: JAI_CMN_TAXES_ALL D
100: WHERE TAX_TYPE LIKE CP_TAX_TYPE
101: AND D.TAX_ID = A.NEW_TAX_ID )
102: GROUP BY
103: C.CUSTOMER_TRX_ID,

Line 117: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

113: END CSTFORMULA;
114:
115: FUNCTION OTHERS_FORMULA(CUSTOMER_TRX_ID IN NUMBER
116: ,SUPP_INV_TYPE IN VARCHAR2) RETURN NUMBER IS
117: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
118: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
119: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
120: CURSOR OTHERS IS
121: SELECT

Line 118: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

114:
115: FUNCTION OTHERS_FORMULA(CUSTOMER_TRX_ID IN NUMBER
116: ,SUPP_INV_TYPE IN VARCHAR2) RETURN NUMBER IS
117: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
118: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
119: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
120: CURSOR OTHERS IS
121: SELECT
122: SUM(DIFF_AMT) OTHER

Line 119: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

115: FUNCTION OTHERS_FORMULA(CUSTOMER_TRX_ID IN NUMBER
116: ,SUPP_INV_TYPE IN VARCHAR2) RETURN NUMBER IS
117: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
118: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
119: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
120: CURSOR OTHERS IS
121: SELECT
122: SUM(DIFF_AMT) OTHER
123: FROM

Line 137: JAI_CMN_TAXES_ALL D

133: AND EXISTS (
134: SELECT
135: 1
136: FROM
137: JAI_CMN_TAXES_ALL D
138: WHERE TAX_TYPE not LIKE LV_EXCISE
139: AND TAX_TYPE NOT LIKE LV_CST
140: AND TAX_TYPE not like LV_SALES_TAX
141: AND D.TAX_ID = A.NEW_TAX_ID )