APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_LINES_UPG_SYNC_DATA

Line 72: FROM AP_Lines_Upg_Sync_Data;

68:
69:
70: SELECT DISTINCT invoice_id
71: BULK COLLECT INTO sync_invs
72: FROM AP_Lines_Upg_Sync_Data;
73:
74:
75: FORALL i IN 1..sync_invs.COUNT
76: DELETE FROM AP_Invoice_Lines_All

Line 593: FROM AP_Lines_Upg_Sync_Data

589: AP_Inv_Dists_Source AID,
590: AP_Inv_Dists_Source AID1,
591: ZX_Rates_B ZXR
592: WHERE AI.Invoice_ID IN (SELECT Distinct Invoice_ID
593: FROM AP_Lines_Upg_Sync_Data
594: WHERE Status = 'S')
595: AND AI.Invoice_ID = AID.Invoice_ID
596: AND AID.Invoice_ID = AID1.Invoice_ID (+)
597: AND AID.Parent_Reversal_ID = AID1.Invoice_Distribution_ID (+)

Line 2430: UPDATE ap_lines_upg_sync_data

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

Line 2443: DELETE FROM ap_lines_upg_sync_data

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