[Home] [Help]
396: END is_accrual_basis;
397:
398:
399: procedure get_regime_info ( p_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
400: p_tax_type_code JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,
401: p_regime_id OUT NOCOPY JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
402: p_error_flag OUT NOCOPY VARCHAR2 ,
403: p_error_message OUT NOCOPY VARCHAR2
404: )
435: /*
436: || Check whether a tax type exists in the regime registrations table for the
437: || tax types attached to a invoice tax line.
438: */
439: CURSOR c_chk_service_tax ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,
440: cp_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE
441: )
442: IS
443: SELECT
806: ra_cust_trx_types_all trx_types ,
807: JAI_AR_TRX_LINES jtrxl ,
808: JAI_AR_TRX_TAX_LINES jtrxtl ,
809: ra_customer_trx_lines_all rctla , /*14121914*/
810: JAI_CMN_TAXES_ALL jtc ,
811: ra_cust_trx_line_gl_dist_all gd--Added by Qiong for bug13540741
812: WHERE
813: trx.org_id = nvl(p_org_id,trx.org_id) AND
814: trx.complete_flag ='Y' AND
922: acra.amount receipt_amount
923: FROM ar_cash_receipts_all acra,
924: jai_ar_cash_receipts_all jcra,
925: jai_cmn_document_taxes jdt ,
926: JAI_CMN_TAXES_ALL jtc ,
927: jai_regime_tax_types_v jrttv
928: WHERE acra.cash_receipt_id = jcra.cash_receipt_id
929: AND jdt.tax_id = jtc.tax_id
930: AND jtc.tax_type = jrttv.tax_type
1856: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
1857: FROM
1858: JAI_AR_TRX_LINES jrtl
1859: , JAI_AR_TRX_TAX_LINES jrttl
1860: , jai_cmn_taxes_all tax
1861: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
1862: AND jrtl.customer_trx_id = pn_cm_customer_trx_id
1863: AND jrttl.tax_id = tax.tax_id
1864: AND NVL(tax.inclusive_tax_flag,'N') = 'Y' ;
2695: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
2696: FROM
2697: JAI_AR_TRX_LINES jrtl ,
2698: JAI_AR_TRX_TAX_LINES jrttl ,
2699: jai_cmn_taxes_all tax
2700: WHERE
2701: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
2702: jrtl.customer_trx_line_id = nvl(cp_inv_cus_trx_line_id, jrtl.customer_trx_line_id) AND
2703: jrttl.customer_trx_line_id = nvl(cp_inv_tax_trx_line_id, jrttl.customer_trx_line_id) AND
2719: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
2720: FROM
2721: JAI_AR_TRX_LINES jrtl
2722: , JAI_AR_TRX_TAX_LINES jrttl
2723: , jai_cmn_taxes_all tax
2724: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
2725: AND jrtl.customer_trx_id = pn_inv_customer_trx_id
2726: AND jrtl.customer_trx_line_id = nvl(pn_inv_cus_trx_line_id, jrtl.customer_trx_line_id)
2727: AND jrttl.customer_trx_line_id = nvl(pn_inv_tax_trx_line_id, jrttl.customer_trx_line_id)
3511: SELECT jcta.tax_type, jattl.customer_trx_line_id, trx.trx_date,
3512: jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100 tax_amt
3513: FROM jai_ar_trx_tax_lines jattl
3514: , ra_customer_trx_all trx
3515: , jai_cmn_taxes_all jcta
3516: WHERE trx.customer_trx_id = pn_invoice_id
3517: AND jattl.link_to_cust_trx_line_id = pn_line_number
3518: AND jattl.tax_id = jcta.tax_id
3519: AND nvl(jcta.mod_cr_percentage,0) > 0
3549: SELECT jcta.tax_type, (jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100) tax_amt,
3550: jattl.customer_trx_line_id, trx.trx_date
3551: FROM jai_ar_trx_tax_lines jattl
3552: , ra_customer_trx_all trx
3553: , jai_cmn_taxes_all jcta
3554: WHERE trx.customer_trx_id = pn_invoice_id
3555: AND jattl.link_to_cust_trx_line_id = pn_line_number
3556: AND jattl.tax_id = jcta.tax_id
3557: AND nvl(jcta.mod_cr_percentage,0) > 0
3637: jdt.tax_amt,
3638: jdt.func_tax_amt
3639: FROM jai_cmn_document_taxes jdt
3640: , jai_ar_cash_receipts_all jacr
3641: , jai_cmn_taxes_all jcta
3642: , jai_regime_tax_types_v jrttv
3643: WHERE jacr.cash_receipt_id = cn_cash_receipt_id
3644: AND jdt.source_doc_id = jacr.cash_receipt_id
3645: AND jdt.tax_id = jcta.tax_id
5091: jdt.tax_amt tax_amount ,
5092: jdt.func_tax_amt
5093: FROM
5094: jai_cmn_document_taxes jdt ,
5095: JAI_CMN_TAXES_ALL jtc ,
5096: jai_regime_tax_types_v jrttv
5097: WHERE
5098: jdt.tax_id = jtc.tax_id
5099: AND jtc.tax_type = jrttv.tax_type