APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 925: jai_cmn_document_taxes jdt ,

921: jdt.func_tax_amt,
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

Line 3639: FROM jai_cmn_document_taxes jdt

3635: SELECT jdt.doc_tax_id,
3636: jdt.tax_type,
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

Line 5094: jai_cmn_document_taxes jdt ,

5090: jtc.tax_type ,
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

Line 6018: jai_cmn_document_taxes jdt,

6014: CURSOR cur_chk_st_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
6015: IS
6016: SELECT 1
6017: FROM jai_ar_cash_receipts_all jcra,
6018: jai_cmn_document_taxes jdt,
6019: jai_regime_tax_types_v jrttv
6020: WHERE jcra.cash_receipt_id = cp_cash_receipt_id
6021: AND jcra.cash_receipt_id = jdt.source_doc_id
6022: AND jdt.tax_type = jrttv.tax_type

Line 6092: jai_cmn_document_taxes jdt ,

6088: SELECT
6089: 1
6090: FROM
6091: jai_ar_cash_receipts_all jcra ,
6092: jai_cmn_document_taxes jdt ,
6093: jai_regime_tax_types_v jrttv
6094: WHERE
6095: jcra.cash_receipt_id = cp_cash_receipt_id
6096: AND jcra.cash_receipt_id = jdt.source_doc_id