DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_UTILS dependencies on AP_INVOICES_ALL

Line 2392: AP_INVOICES_ALL AI

2388: CURSOR C_get_prepay_parent_id IS
2389: SELECT APAD.REVERSED_PREPAY_APP_DIST_ID
2390: FROM AP_PREPAY_APP_DISTS APAD,
2391: AP_PREPAY_HISTORY_ALL APPH,
2392: AP_INVOICES_ALL AI
2393: WHERE APAD.Prepay_App_Distribution_ID = p_document_distribution_id
2394: AND APPH.prepay_history_id = APAD.prepay_history_id
2395: AND AI.invoice_id = APPH.invoice_id
2396: AND decode(p_event_type_code, 'PREPAYMENT UNAPPLIED', decode(nvl(AI.historical_flag,'N'), 'Y','N',