APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_ST_REVERSAL_EXTRACT_PKG

Line 980: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(aipa.accounting_date,

976: AND jrtr.source_document_id = aipa.invoice_payment_id)
977: AND EXISTS (SELECT 1
978: FROM ap_invoice_distributions_all aida
979: WHERE aida.invoice_id = pn_invoice_id
980: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(aipa.accounting_date,
981: aida.accounting_date, 'AP') = 'Y')
982: UNION ALL
983: SELECT abs(nvl(aila.amount, 0)) claim_amt, aipa.invoice_payment_id, aila.accounting_date
984: FROM ap_invoice_lines_all aila,

Line 1008: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(aila.accounting_date,

1004: AND jrtr.source_document_id = aipa.invoice_payment_id)
1005: AND EXISTS (SELECT 1
1006: FROM ap_invoice_distributions_all aida
1007: WHERE aida.invoice_id = pn_invoice_id
1008: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(aila.accounting_date,
1009: aida.accounting_date, 'AP') = 'Y')
1010: ORDER BY 2;
1011:
1012: ln_max_payment_id NUMBER;

Line 4843: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(aipa.accounting_date,

4839: AND EXISTS (SELECT 1
4840: FROM ap_invoice_distributions_all aida
4841: WHERE aida.invoice_id = pn_invoice_id
4842: AND aida.invoice_line_number = pn_line_number
4843: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(aipa.accounting_date,
4844: aida.accounting_date, 'AP') = 'Y')
4845: UNION ALL
4846: SELECT abs(nvl(aila.amount, 0)) claim_amt, aipa.invoice_payment_id, aipa.accounting_date
4847: FROM ap_invoice_lines_all aila,

Line 4882: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(aila.accounting_date,

4878: AND EXISTS (SELECT 1
4879: FROM ap_invoice_distributions_all aida
4880: WHERE aida.invoice_id = pn_invoice_id
4881: AND aida.invoice_line_number = pn_line_number
4882: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(aila.accounting_date,
4883: aida.accounting_date, 'AP') = 'Y')
4884: ORDER BY 2;
4885:
4886: CURSOR get_service_type_code_cur(pn_invoice_id NUMBER, pn_invoice_line_number NUMBER) IS