APPS.MSC_ANALYSIS_SAFETY_STOCK dependencies on MSC_PLANS_TREE_V

Line 812: FROM msc_plans_tree_v mpt, msc_plans mp

808: RETURN BOOLEAN
809: IS
810: CURSOR c1(p_plan_id NUMBER) IS
811: SELECT 1
812: FROM msc_plans_tree_v mpt, msc_plans mp
813: WHERE mpt.curr_plan_type = 4
814: AND mpt.plan_id = mp.plan_id
815: AND mp.plan_start_date IS NOT NULL
816: AND mp.plan_id = p_plan_id;