APPS.MSC_DS_SCHEDULE dependencies on MSC_PLANS

Line 31: from msc_plans p

27: and order_type = 3
28: and nvl(release_status,2) = 2
29: and nvl(category_set_id, p_cat_set_id) = p_cat_set_id
30: and new_order_date <= (select p.plan_start_date + p_recom_days
31: from msc_plans p
32: where p.plan_id = p_plan_id );
33:
34: begin
35: p_resched_total := 0;