DBA Data[Home] [Help]

APPS.MSD_ASCP_FLOW dependencies on MSC_PLAN_ORGANIZATIONS

Line 38: FROM msc_plan_organizations

34: AND scenario_id = l_default_scenario_id;
35:
36: CURSOR c_org_id (l_plan_id IN NUMBER) IS
37: SELECT organization_id, sr_instance_id
38: FROM msc_plan_organizations
39: WHERE plan_id = l_plan_id;
40:
41: CURSOR c_sch_count (l_plan_id IN NUMBER,l_instance_id IN NUMBER, l_org_id IN NUMBER, l_default_scenario_iD IN NUMBER) IS
42: SELECT count(*)