DBA Data[Home] [Help]

APPS.AP_RECONCILIATION_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 1822: FROM ap_payment_history_all APHA,

1818: APHA.charges_base_amount,
1819: C.check_id,
1820: NVL(c.amount, 0),
1821: c.org_id
1822: FROM ap_payment_history_all APHA,
1823: ap_checks_all C
1824: WHERE APHA.check_id = C.check_id
1825: AND C.checkrun_id = X_CHECKRUN_ID
1826: AND C.org_id = p_org_id -- Bug 5674397

Line 2338: INSERT INTO AP_PAYMENT_HISTORY_ALL

2334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2335: END IF;
2336: ---------------------------------------------------------------
2337:
2338: INSERT INTO AP_PAYMENT_HISTORY_ALL
2339: ( PAYMENT_HISTORY_ID,
2340: CHECK_ID,
2341: ACCOUNTING_DATE,
2342: TRANSACTION_TYPE,