APPS.JAI_AP_DTC_CANCELLATION_PKG dependencies on JAI_AP_TDS_THGRP_AUDITS

Line 73: FROM jai_ap_tds_thgrp_audits

69: CURSOR c_get_trx_invoice_amount(p_inv_id NUMBER
70: ,p_threshold_grp_id NUMBER
71: ) IS
72: SELECT NVL(SUM(trx_invoice_amount),0) trx_invoice_amount
73: FROM jai_ap_tds_thgrp_audits
74: WHERE invoice_id = p_inv_id
75: AND threshold_grp_id = p_threshold_grp_id
76: AND tds_event = 'INVOICE VALIDATE'
77: AND trx_invoice_amount IS NOT NULL

Line 1045: --TRX_INVOICE_AMOUNT from JAI_AP_TDS_THGRP_AUDITS

1041: ln_taxable_amount := cur_rec.taxable_amount * ln_exchange_rate;
1042: end if;
1043:
1044: */
1045: --TRX_INVOICE_AMOUNT from JAI_AP_TDS_THGRP_AUDITS
1046: OPEN c_get_trx_invoice_amount(p_invoice_id,cur_rec.threshold_grp_id );
1047: FETCH c_get_trx_invoice_amount INTO ln_trx_invoice_amount;
1048: CLOSE c_get_trx_invoice_amount;
1049: