DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on AP_INVOICE_RELATIONSHIPS

Line 166: ap_invoice_relationships ir

162: SELECT i.invoice_id
163: FROM ap_invoice_payments_all aip,
164: ap_checks_all c,
165: ap_invoices_all i,
166: ap_invoice_relationships ir
167: WHERE c.check_id = p_check_id
168: AND c.check_id = aip.check_id
169: AND aip.invoice_id = ir.related_invoice_id
170: AND aip.invoice_id = i.invoice_id

Line 1427: l_debug_info := 'INSERT INTO ap_invoice_relationships';

1423: AND fcinv.currency_code = orig.invoice_currency_code;
1424:
1425:
1426:
1427: l_debug_info := 'INSERT INTO ap_invoice_relationships';
1428: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1429: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1430: END IF;
1431:

Line 1432: INSERT INTO ap_invoice_relationships(

1428: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1429: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1430: END IF;
1431:
1432: INSERT INTO ap_invoice_relationships(
1433: original_invoice_id,
1434: related_invoice_id,
1435: created_by,
1436: creation_date,