144:
145: cursor c_get_regime_attr_value (cp_attr_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE)
146: is
147: SELECT jrr.ATTRIBUTE_VALUE
148: FROM JAI_RGM_DEFINITIONS jrd,
149: JAI_RGM_REGISTRATIONS jrr
150: WHERE jrd.REGIME_ID = jrr.REGIME_ID
151: AND jrr.ATTRIBUTE_CODE = cp_attr_code
152: AND jrd.REGIME_CODE = 'TDS';
400: AND JCDT.TAX_ID = JCTA.TAX_ID
401: AND JCTA.TAX_TYPE IN (SELECT ATTRIBUTE_CODE
402: FROM JAI_RGM_REGISTRATIONS
403: WHERE REGIME_ID = (SELECT REGIME_ID
404: FROM JAI_RGM_DEFINITIONS
405: WHERE REGIME_CODE =JAI_CONSTANTS.SERVICE_REGIME)
406: AND REGISTRATION_TYPE = 'TAX_TYPES');
407:
408: -- cursor to Check if Service Tax exists for PO matched Invoice
416: AND JAMIT.TAX_ID = JCTA.TAX_ID
417: AND JCTA.TAX_TYPE IN (SELECT ATTRIBUTE_CODE
418: FROM JAI_RGM_REGISTRATIONS
419: WHERE REGIME_ID = (SELECT REGIME_ID
420: FROM JAI_RGM_DEFINITIONS
421: WHERE REGIME_CODE =JAI_CONSTANTS.SERVICE_REGIME)
422: AND REGISTRATION_TYPE = 'TAX_TYPES');
423:
424: -- cursor to get parent distribution id for po matched
516: AND JCT.TAX_TYPE
517: IN (SELECT ATTRIBUTE_CODE
518: FROM JAI_RGM_REGISTRATIONS
519: WHERE REGIME_ID = (SELECT REGIME_ID
520: FROM JAI_RGM_DEFINITIONS
521: WHERE REGIME_CODE ='SERVICE')
522: AND REGISTRATION_TYPE = 'TAX_TYPES');
523:
524: CURSOR c_match_inclu_taxes (cp_inv_dist_id number)
531: AND JCT.TAX_TYPE
532: IN (SELECT ATTRIBUTE_CODE
533: FROM JAI_RGM_REGISTRATIONS
534: WHERE REGIME_ID = (SELECT REGIME_ID
535: FROM JAI_RGM_DEFINITIONS
536: WHERE REGIME_CODE ='SERVICE')
537: AND REGISTRATION_TYPE = 'TAX_TYPES');
538: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 end.
539:
2194: AND JCT.TAX_TYPE
2195: IN (SELECT ATTRIBUTE_CODE
2196: FROM JAI_RGM_REGISTRATIONS
2197: WHERE REGIME_ID = (SELECT REGIME_ID
2198: FROM JAI_RGM_DEFINITIONS
2199: WHERE REGIME_CODE ='SERVICE')
2200: AND REGISTRATION_TYPE = 'TAX_TYPES')
2201: )
2202: AND NOT EXISTS (SELECT 1
2207: AND JCT.TAX_TYPE
2208: IN (SELECT ATTRIBUTE_CODE
2209: FROM JAI_RGM_REGISTRATIONS
2210: WHERE REGIME_ID = (SELECT REGIME_ID
2211: FROM JAI_RGM_DEFINITIONS
2212: WHERE REGIME_CODE ='SERVICE')
2213: AND REGISTRATION_TYPE = 'TAX_TYPES')
2214: )
2215: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 end.
2260: AND JCT.TAX_TYPE
2261: IN (SELECT ATTRIBUTE_CODE
2262: FROM JAI_RGM_REGISTRATIONS
2263: WHERE REGIME_ID = (SELECT REGIME_ID
2264: FROM JAI_RGM_DEFINITIONS
2265: WHERE REGIME_CODE ='SERVICE')
2266: AND REGISTRATION_TYPE = 'TAX_TYPES')
2267: )
2268: AND NOT EXISTS (SELECT 1
2273: AND JCT.TAX_TYPE
2274: IN (SELECT ATTRIBUTE_CODE
2275: FROM JAI_RGM_REGISTRATIONS
2276: WHERE REGIME_ID = (SELECT REGIME_ID
2277: FROM JAI_RGM_DEFINITIONS
2278: WHERE REGIME_CODE ='SERVICE')
2279: AND REGISTRATION_TYPE = 'TAX_TYPES')
2280: )
2281: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 end.
2321: AND JCT.TAX_TYPE
2322: IN (SELECT ATTRIBUTE_CODE
2323: FROM JAI_RGM_REGISTRATIONS
2324: WHERE REGIME_ID = (SELECT REGIME_ID
2325: FROM JAI_RGM_DEFINITIONS
2326: WHERE REGIME_CODE ='SERVICE')
2327: AND REGISTRATION_TYPE = 'TAX_TYPES')
2328: )
2329: AND NOT EXISTS (SELECT 1
2334: AND JCT.TAX_TYPE
2335: IN (SELECT ATTRIBUTE_CODE
2336: FROM JAI_RGM_REGISTRATIONS
2337: WHERE REGIME_ID = (SELECT REGIME_ID
2338: FROM JAI_RGM_DEFINITIONS
2339: WHERE REGIME_CODE ='SERVICE')
2340: AND REGISTRATION_TYPE = 'TAX_TYPES')
2341: )
2342: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 end.
2389: AND JCT.TAX_TYPE
2390: IN (SELECT ATTRIBUTE_CODE
2391: FROM JAI_RGM_REGISTRATIONS
2392: WHERE REGIME_ID = (SELECT REGIME_ID
2393: FROM JAI_RGM_DEFINITIONS
2394: WHERE REGIME_CODE ='SERVICE')
2395: AND REGISTRATION_TYPE = 'TAX_TYPES')
2396: )
2397: AND NOT EXISTS (SELECT 1
2402: AND JCT.TAX_TYPE
2403: IN (SELECT ATTRIBUTE_CODE
2404: FROM JAI_RGM_REGISTRATIONS
2405: WHERE REGIME_ID = (SELECT REGIME_ID
2406: FROM JAI_RGM_DEFINITIONS
2407: WHERE REGIME_CODE ='SERVICE')
2408: AND REGISTRATION_TYPE = 'TAX_TYPES')
2409: )
2410: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 end.