DBA Data[Home] [Help]

APPS.AP_RECONCILIATION_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 1494: FROM ap_payment_history_all APHA,

1490: APHA.charges_base_amount,
1491: C.check_id,
1492: NVL(c.amount, 0),
1493: c.org_id
1494: FROM ap_payment_history_all APHA,
1495: ap_checks_all C
1496: WHERE APHA.check_id = C.check_id
1497: AND C.checkrun_id = X_CHECKRUN_ID
1498: AND C.org_id = p_org_id -- Bug 5674397

Line 1952: INSERT INTO AP_PAYMENT_HISTORY_ALL

1948: -- Insert payment information into payment history table
1949: ----------------------------------------------------------------
1950: l_debug_info := 'Inserting into AP_Payment_History';
1951:
1952: INSERT INTO AP_PAYMENT_HISTORY_ALL
1953: ( PAYMENT_HISTORY_ID,
1954: CHECK_ID,
1955: ACCOUNTING_DATE,
1956: TRANSACTION_TYPE,