APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_ST_INVOICE_REVERSAL

Line 3529: FROM jai_st_invoice_reversal

3525: AND source_document_id = jattl.customer_trx_line_id);
3526:
3527: CURSOR get_reversal_amount_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER) IS
3528: SELECT reversal_amount, date_of_reversal
3529: FROM jai_st_invoice_reversal
3530: WHERE invoice_id = pn_invoice_id
3531: AND customer_trx_line_id = pn_line_number
3532: AND SOURCE = 'AR';
3533:

Line 3567: FROM jai_st_invoice_reversal jsir

3563: AND source_document_id = jattl.customer_trx_line_id);
3564:
3565: CURSOR get_claim_trxn_cur IS
3566: SELECT jsir.*
3567: FROM jai_st_invoice_reversal jsir
3568: WHERE jsir.source = 'AR'
3569: AND jsir.tax_to_be_adjusted > 0
3570: ORDER BY jsir.invoice_id;
3571:

Line 3574: FROM jai_st_invoice_reversal jsir

3570: ORDER BY jsir.invoice_id;
3571:
3572: CURSOR get_reversal_trxn_cur IS
3573: SELECT jsir.*
3574: FROM jai_st_invoice_reversal jsir
3575: WHERE jsir.source = 'AR'
3576: AND jsir.date_of_reversal BETWEEN p_from_date AND p_to_date;
3577:
3578: CURSOR get_claim_amt_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER, pn_max_payment_id IN NUMBER) IS

Line 4558: FROM jai_st_invoice_reversal jsir

4554: pn_organization_id IN NUMBER) IS
4555:
4556: CURSOR get_claim_trxn_cur IS
4557: SELECT jsir.*
4558: FROM jai_st_invoice_reversal jsir
4559: WHERE jsir.source = 'AR'
4560: AND jsir.tax_to_be_adjusted > 0;
4561:
4562: CURSOR get_claim_amt_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER, pn_max_payment_id IN NUMBER) IS

Line 4613: UPDATE jai_st_invoice_reversal

4609: END IF;
4610:
4611: END LOOP;
4612: IF nvl(ln_max_payment_id, 0) > nvl(reversal_trxn_rec.max_claim_payment_id, 0) THEN
4613: UPDATE jai_st_invoice_reversal
4614: SET max_claim_payment_id = ln_max_payment_id
4615: WHERE invoice_id = reversal_trxn_rec.invoice_id
4616: AND customer_trx_line_id = reversal_trxn_rec.customer_trx_line_id
4617: AND SOURCE = 'AR';