APPS.AHL_UMP_BOM_PVT dependencies on AHL_SIMULATION_PLANS_TL

Line 3332: FROM ahl_simulation_plans_tl tl, ahl_simulation_plans_b b

3328: G_DEBUG_LINE_NUM := l_debug_module||': '||450;
3329: BEGIN
3330: SELECT b.simulation_plan_id, b.primary_plan_flag
3331: INTO l_plan_id, l_primary_plan_flag
3332: FROM ahl_simulation_plans_tl tl, ahl_simulation_plans_b b
3333: WHERE UPPER(tl.simulation_plan_name) = UPPER(p_sim_plan_name)
3334: AND b.simulation_plan_id = tl.simulation_plan_id
3335: AND b.status_code = 'ACTIVE'
3336: AND b.simulation_type = 'UMP'