APPS.MSC_GANTT_UTILS dependencies on MSC_PLAN_ORGANIZATIONS

Line 1849: from msc_plan_organizations

1845:
1846: cursor c_ds_orgs is
1847: select organization_id,
1848: nvl(curr_frozen_horizon_days, frozen_horizon_days) frozen_days
1849: from msc_plan_organizations
1850: where plan_id = p_plan_id
1851: and nvl(nvl(curr_ds_enabled_flag, ds_enabled_flag),2) = 1;
1852:
1853: v_org_id number_arr;

Line 3170: from msc_plan_organizations mpo,

3166: p_dept number, p_res number, p_start_date date, p_end_date date) return number is
3167:
3168: cursor c_res_row is
3169: select sys_yes
3170: from msc_plan_organizations mpo,
3171: msc_resource_requirements mrr,
3172: msc_department_resources mdr,
3173: msc_plans mp
3174: where mrr.plan_id = p_plan

Line 3281: msc_plan_organizations mpo,

3277: msc_supplies ms,
3278: msc_items mi,
3279: msc_items mi2,
3280: msc_gantt_query mgq,
3281: msc_plan_organizations mpo,
3282: msc_plans mp
3283: where mgq.query_id = p_query_id
3284: and mgq.row_flag = SYS_YES
3285: and ( ( p_batched_res_act = RES_REQ_ROW_TYPE )

Line 3478: msc_plan_organizations mpo,

3474: to_char(sum(mrr.capacity_consumed_ratio))) bar_text
3475: from msc_resource_requirements mrr,
3476: msc_supplies ms,
3477: msc_gantt_query mgq,
3478: msc_plan_organizations mpo,
3479: msc_department_resources mdr,
3480: msc_plans mp
3481: where mgq.query_id = p_query_id
3482: and mgq.row_flag = SYS_YES