DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on MRP_PLANS

Line 17: FROM mrp_plans plan,

13: OR (code=1 AND planned_org=p_owning_org_id));
14:
15: CURSOR PLAN_BOUNDS_C(p_org_type IN NUMBER) IS
16: SELECT trunc(plan.data_start_date), trunc(plan.cutoff_date)
17: FROM mrp_plans plan,
18: mrp_plan_organizations_v org
19: WHERE DECODE(p_org_type, 1, org.planned_organization,
20: org.organization_id) = p_owning_org_id
21: AND org.compile_designator = p_designator