APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 927: jai_regime_tax_types_v jrttv

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
931: AND jdt.source_doc_id = jcra.cash_receipt_id

Line 3642: , jai_regime_tax_types_v jrttv

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
3646: AND jcta.tax_type = jrttv.tax_type

Line 5096: jai_regime_tax_types_v jrttv

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
5100: AND jdt.source_doc_id = p_acra.cash_receipt_id

Line 6019: jai_regime_tax_types_v jrttv

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
6023: AND jrttv.regime_code = jai_constants.service_regime

Line 6093: jai_regime_tax_types_v jrttv

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
6097: AND jdt.tax_type = jrttv.tax_type