APPS.GMF_ALLOC_PROC dependencies on GMF_XLA_EXTRACT_HEADERS

Line 304: SELECT event_id, ledger_id FROM gmf_xla_extract_headers

300: )
301: IS
302: -- Bug 12561766 begins
303: CURSOR events_To_Delete IS
304: SELECT event_id, ledger_id FROM gmf_xla_extract_headers
305: WHERE entity_code = 'REVALUATION'
306: AND event_class_code = 'GLCOSTALOC'
307: AND accounted_flag IS NOT NULL
308: AND transaction_id IN

Line 404: WHERE Header_id IN (SELECT header_id FROM gmf_xla_extract_headers

400: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,c_module||l_local_module, 'Deleting Expense Allocation Events Extract Lines ');
401: END IF;
402:
403: DELETE FROM gmf_xla_extract_lines
404: WHERE Header_id IN (SELECT header_id FROM gmf_xla_extract_headers
405: WHERE entity_code = 'REVALUATION'
406: AND event_class_code = 'GLCOSTALOC'
407: AND accounted_flag IS NOT NULL
408: AND event_id IN (select event_id from xla_events_int_gt)

Line 417: DELETE FROM gmf_xla_extract_headers

413: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
414: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,c_module||l_local_module, 'Deleting Expense Allocation Events Extract Headers ');
415: END IF;
416:
417: DELETE FROM gmf_xla_extract_headers
418: WHERE entity_code = 'REVALUATION'
419: AND event_class_code = 'GLCOSTALOC'
420: AND accounted_flag IS NOT NULL
421: AND event_id IN (select event_id from xla_events_int_gt);