DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on AP_INVOICE_RELATIONSHIPS

Line 193: ap_invoice_relationships ir

189: SELECT i.invoice_id
190: FROM ap_invoice_payments_all aip,
191: ap_checks_all c,
192: ap_invoices_all i,
193: ap_invoice_relationships ir
194: WHERE c.check_id = p_check_id
195: AND c.check_id = aip.check_id
196: AND aip.invoice_id = ir.related_invoice_id
197: AND aip.invoice_id = i.invoice_id

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

1595: AND fcinv.currency_code = orig.invoice_currency_code;
1596:
1597:
1598:
1599: l_debug_info := 'INSERT INTO ap_invoice_relationships';
1600: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1601: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1602: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1603: END IF;

Line 1605: INSERT INTO ap_invoice_relationships(

1601: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1602: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1603: END IF;
1604:
1605: INSERT INTO ap_invoice_relationships(
1606: original_invoice_id,
1607: related_invoice_id,
1608: created_by,
1609: creation_date,