DBA Data[Home] [Help]

APPS.AP_INVOICES_INTERFACE_PKG dependencies on AP_INVOICE_LINES_INTERFACE

Line 1380: FROM ap_invoice_lines_interface

1376:
1377: /* Delete invoice lines rejections from the rejections table */
1378: DELETE FROM ap_interface_rejections
1379: WHERE parent_id IN (SELECT invoice_line_id
1380: FROM ap_invoice_lines_interface
1381: WHERE invoice_id = X_INVOICE_ID)
1382: and parent_table = 'AP_INVOICE_LINES_INTERFACE';
1383:
1384: /* Delete invoice lines from interface */

Line 1382: and parent_table = 'AP_INVOICE_LINES_INTERFACE';

1378: DELETE FROM ap_interface_rejections
1379: WHERE parent_id IN (SELECT invoice_line_id
1380: FROM ap_invoice_lines_interface
1381: WHERE invoice_id = X_INVOICE_ID)
1382: and parent_table = 'AP_INVOICE_LINES_INTERFACE';
1383:
1384: /* Delete invoice lines from interface */
1385: DELETE FROM ap_invoice_lines_interface
1386: WHERE invoice_id = X_INVOICE_ID;

Line 1385: DELETE FROM ap_invoice_lines_interface

1381: WHERE invoice_id = X_INVOICE_ID)
1382: and parent_table = 'AP_INVOICE_LINES_INTERFACE';
1383:
1384: /* Delete invoice lines from interface */
1385: DELETE FROM ap_invoice_lines_interface
1386: WHERE invoice_id = X_INVOICE_ID;
1387:
1388: /* Delete invoices from interface */
1389: DELETE FROM AP_INVOICES_INTERFACE