DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_ST_INVOICE_REVERSAL

Line 225: FROM jai_st_invoice_reversal

221: pv_document_line_id VARCHAR2 default NULL) RETURN DATE IS
222: --Added by Qinglei 21-Dec-2011 for bug#13405591
223: CURSOR get_reversal_date_cur IS
224: SELECT date_of_reversal
225: FROM jai_st_invoice_reversal
226: WHERE invoice_id = pn_document_id
227: AND SOURCE = substr(pv_source, 1, 2);
228:
229: CURSOR get_payment_date_cur IS

Line 1870: FROM jai_st_invoice_reversal

1866: where invoice_id = p_document_id;
1867:
1868: CURSOR c_get_open_amount IS
1869: SELECT open_amt, original_line_amt
1870: FROM jai_st_invoice_reversal
1871: WHERE invoice_id = p_document_id
1872: AND line_num = p_document_line_id;
1873:
1874: CURSOR c_get_claim_paid_amount IS