DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_UTILS dependencies on AP_INVOICES_ALL

Line 2543: AP_INVOICES_ALL AI

2539: CURSOR C_get_prepay_parent_id IS
2540: SELECT APAD.REVERSED_PREPAY_APP_DIST_ID
2541: FROM AP_PREPAY_APP_DISTS APAD,
2542: AP_PREPAY_HISTORY_ALL APPH,
2543: AP_INVOICES_ALL AI
2544: WHERE APAD.Prepay_App_Distribution_ID = p_document_distribution_id
2545: AND APPH.prepay_history_id = APAD.prepay_history_id
2546: AND AI.invoice_id = APPH.invoice_id
2547: AND decode(p_event_type_code, 'PREPAYMENT UNAPPLIED', decode(nvl(AI.historical_flag,'N'), 'Y','N',