APPS.MSC_PHUB_FILE_PKG dependencies on MSD_DP_ASCP_SCENARIOS_V

Line 590: from msd_dp_ascp_scenarios_v das, msd_dem_transfer_query tq

586: (select plan_id, compile_designator, plan_type
587: from msc_plans
588: union
589: select das.scenario_id, substr(das.scenario_name, 1, 50), 10
590: from msd_dp_ascp_scenarios_v das, msd_dem_transfer_query tq
591: where das.demand_plan_id=5555555
592: and das.demand_plan_name = substr(tq.query_name, 1, 30))
593: where compile_designator=l_pi.plan_name
594: and rownum=1;