DBA Data[Home] [Help]

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_ST_REVERSAL_EXTRACT_PKG

Line 3596: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(araa.apply_date,

3592: FROM ra_cust_trx_line_gl_dist_all rg
3593: WHERE rg.customer_trx_id = pn_invoice_id
3594: AND rg.customer_trx_line_id = pn_line_number
3595: AND rg.account_class = 'REV'
3596: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(araa.apply_date,
3597: rg.gl_date, 'AR') = 'Y');
3598:
3599: /* Added by Wenqiong for Advanced Receipts on Service Taxes Begin*/
3600: CURSOR c_ar_receipts

Line 4580: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(araa.apply_date,

4576: FROM ra_cust_trx_line_gl_dist_all rg
4577: WHERE rg.customer_trx_id = pn_invoice_id
4578: AND rg.customer_trx_line_id = pn_line_number
4579: AND rg.account_class = 'REV'
4580: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(araa.apply_date,
4581: rg.gl_date, 'AR') = 'Y');
4582:
4583: ln_max_payment_id NUMBER;
4584: