APPS.XLA_EXTRACT_INTEGRITY_PKG dependencies on XLA_SUBLEDGERS

Line 2365: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og, xla_subledgers app

2361: /*
2362: CURSOR c_aad_ledger_id
2363: IS
2364: SELECT distinct extract_object_name, extract_object_type_code
2365: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og, xla_subledgers app
2366: WHERE e.application_id = p_application_id
2367: AND e.entity_code = p_entity_code
2368: AND e.event_class_code = p_event_class_code
2369: AND e.extract_object_name IS NOT NULL

Line 2383: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og, xla_subledgers app

2379: AND t.data_type = 'NUMBER'); */
2380: CURSOR c_aad_ledger_id
2381: IS
2382: SELECT distinct extract_object_name, extract_object_type_code
2383: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og, xla_subledgers app
2384: WHERE e.application_id = p_application_id
2385: AND e.entity_code = p_entity_code
2386: AND e.event_class_code = p_event_class_code
2387: AND e.extract_object_name IS NOT NULL

Line 2644: FROM xla_extract_objects e, xla_extract_objects_gt og, xla_subledgers app

2640: -- Added and commented for bug 15938563
2641: /* CURSOR c_ledger_id
2642: IS
2643: SELECT e.object_name, object_type_code
2644: FROM xla_extract_objects e, xla_extract_objects_gt og, xla_subledgers app
2645: WHERE e.application_id = p_application_id
2646: AND e.entity_code = p_entity_code
2647: AND e.event_class_code = p_event_class_code
2648: AND e.object_type_code IN ('LINE','LINE_MLS')

Line 2664: FROM xla_extract_objects e, xla_extract_objects_gt og, xla_subledgers app

2660: WHERE a.object_name = e.object_name); */
2661: CURSOR c_ledger_id
2662: IS
2663: SELECT e.object_name, object_type_code
2664: FROM xla_extract_objects e, xla_extract_objects_gt og, xla_subledgers app
2665: WHERE e.application_id = p_application_id
2666: AND e.entity_code = p_entity_code
2667: AND e.event_class_code = p_event_class_code
2668: AND e.object_type_code IN ('LINE','LINE_MLS')