APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_LINES_UPG_SYNC_DATA

Line 51: FROM AP_Lines_Upg_Sync_Data;

47:
48:
49: SELECT DISTINCT invoice_id
50: BULK COLLECT INTO sync_invs
51: FROM AP_Lines_Upg_Sync_Data;
52:
53:
54: FORALL i IN 1..sync_invs.COUNT
55: DELETE FROM AP_Invoice_Lines_All

Line 572: FROM AP_Lines_Upg_Sync_Data

568: AP_Inv_Dists_Source AID,
569: AP_Inv_Dists_Source AID1,
570: ZX_Rates_B ZXR
571: WHERE AI.Invoice_ID IN (SELECT Distinct Invoice_ID
572: FROM AP_Lines_Upg_Sync_Data
573: WHERE Status = 'S')
574: AND AI.Invoice_ID = AID.Invoice_ID
575: AND AID.Invoice_ID = AID1.Invoice_ID (+)
576: AND AID.Parent_Reversal_ID = AID1.Invoice_Distribution_ID (+)

Line 2432: UPDATE ap_lines_upg_sync_data

2428: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2429: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_request_id, NULL));
2430:
2431:
2432: UPDATE ap_lines_upg_sync_data
2433: SET Status = 'S';
2434:
2435:
2436: l_debug_info := 'Calling procedure Populate_Lines';

Line 2445: DELETE FROM ap_lines_upg_sync_data

2441:
2442: POPULATE_LINES(l_curr_calling_sequence);
2443:
2444:
2445: DELETE FROM ap_lines_upg_sync_data
2446: WHERE STATUS = 'S';
2447:
2448:
2449: UPDATE ap_invoices_upg_control