APPS.IGI_CIS_UPGRADE_PKG dependencies on AP_AWT_TAX_RATES

Line 11: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN

7: CURSOR C_UPDATE IS
8: SELECT
9: DISTINCT AATR.VENDOR_ID
10: FROM
11: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN
12: WHERE
13: --TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE, SYSDATE)) bug 5620412
14: --AND TRUNC(NVL(END_DATE, SYSDATE)) bug 5620412
15: --AND bug 5620412

Line 67: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN

63: BEGIN
64: SELECT
65: COUNT(DISTINCT(ICCNN.NI_NUMBER)) INTO TEMP_COUNT
66: FROM
67: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN
68: WHERE
69: AATR.VENDOR_ID = C_REC_INFO.VENDOR_ID
70: AND AATR.CERTIFICATE_TYPE IN ('CIS4P', 'CIS4PF', 'CIS6', 'CIS6F')
71: -- AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE, SYSDATE))

Line 90: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN

86: BEGIN
87: SELECT
88: COUNT(DISTINCT(ICCNN.NI_NUMBER)) INTO TEMP_COUNT2
89: FROM
90: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN
91: WHERE
92: AATR.VENDOR_ID = C_REC_INFO.VENDOR_ID
93: AND AATR.CERTIFICATE_TYPE IN ('CIS4P', 'CIS4PF', 'CIS6', 'CIS6F')
94: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(AATR.START_DATE, SYSDATE))

Line 113: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN

109: --Use the NI Number present in the Active Certificate
110: SELECT
111: DISTINCT (ICCNN.NI_NUMBER) INTO TEMP_NI_NUMBER
112: FROM
113: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN
114: WHERE
115: AATR.VENDOR_ID = C_REC_INFO.VENDOR_ID
116: AND AATR.CERTIFICATE_TYPE IN ('CIS4P', 'CIS4PF', 'CIS6', 'CIS6F')
117: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(AATR.START_DATE, SYSDATE))

Line 139: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN

135: ELSE
136: SELECT
137: DISTINCT (ICCNN.NI_NUMBER) INTO TEMP_NI_NUMBER
138: FROM
139: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN
140: WHERE
141: AATR.VENDOR_ID = C_REC_INFO.VENDOR_ID
142: AND AATR.CERTIFICATE_TYPE IN ('CIS4P', 'CIS4PF', 'CIS6', 'CIS6F')
143: -- AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE, SYSDATE))

Line 172: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN

168: BEGIN
169: SELECT
170: COUNT(DISTINCT(SUBSTR (AATR.CERTIFICATE_NUMBER, 1,10))) INTO TEMP_COUNT
171: FROM
172: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN
173: WHERE
174: AATR.VENDOR_ID = C_REC_INFO.VENDOR_ID
175: AND AATR.CERTIFICATE_TYPE IN ('CIS4P', 'CIS4PF', 'CIS4T', 'CIS4TF', 'CIS5', 'CIS5F', 'CIS6', 'CIS6F')
176: --AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE, SYSDATE)) bug 5620412

Line 194: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN

190: BEGIN
191: SELECT
192: COUNT(DISTINCT(SUBSTR (AATR.CERTIFICATE_NUMBER, 1,10))) INTO TEMP_COUNT2
193: FROM
194: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN
195: WHERE
196: AATR.VENDOR_ID = C_REC_INFO.VENDOR_ID
197: AND AATR.CERTIFICATE_TYPE IN ('CIS4P', 'CIS4PF', 'CIS4T', 'CIS4TF', 'CIS5', 'CIS5F', 'CIS6', 'CIS6F')
198: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE, SYSDATE))

Line 216: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN

212: --Use the UTR present in the Active Certificate
213: SELECT
214: DISTINCT(SUBSTR (AATR.CERTIFICATE_NUMBER, 1,10)) INTO TEMP_UTR_NO
215: FROM
216: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN
217: WHERE
218: AATR.VENDOR_ID = C_REC_INFO.VENDOR_ID
219: AND AATR.CERTIFICATE_TYPE IN ('CIS4P', 'CIS4PF', 'CIS4T', 'CIS4TF', 'CIS5', 'CIS5F', 'CIS6', 'CIS6F')
220: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(AATR.START_DATE, SYSDATE))

Line 248: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN

244: ELSE
245: SELECT
246: DISTINCT(SUBSTR (AATR.CERTIFICATE_NUMBER, 1,10)) INTO TEMP_UTR_NO
247: FROM
248: AP_AWT_TAX_RATES AATR, IGI_CIS_CERT_NI_NUMBERS ICCNN
249: WHERE
250: VENDOR_ID = C_REC_INFO.VENDOR_ID
251: AND AATR.CERTIFICATE_TYPE IN ('CIS4P', 'CIS4PF', 'CIS4T', 'CIS4TF', 'CIS5', 'CIS5F', 'CIS6', 'CIS6F')
252: -- AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE, SYSDATE)) bug 5620412