APPS.MSC_ANALYSIS_BUDGET dependencies on MSC_PLANS_TREE_V

Line 642: FROM msc_plans_tree_v mpt, msc_plans mp

638: RETURN BOOLEAN
639: IS
640: CURSOR c1(p_plan_id NUMBER) IS
641: SELECT 1
642: FROM msc_plans_tree_v mpt, msc_plans mp
643: WHERE mpt.curr_plan_type = 4
644: AND mpt.plan_id = mp.plan_id
645: AND mp.plan_start_date IS NOT NULL
646: AND mp.plan_id = p_plan_id;