APPS.MSC_GANTT_UTILS dependencies on MSC_PLAN_ORGANIZATIONS

Line 1848: from msc_plan_organizations

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

Line 3165: from msc_plan_organizations mpo,

3161: p_dept number, p_res number, p_start_date date, p_end_date date) return number is
3162:
3163: cursor c_res_row is
3164: select sys_yes
3165: from msc_plan_organizations mpo,
3166: msc_resource_requirements mrr,
3167: msc_department_resources mdr,
3168: msc_plans mp
3169: where mrr.plan_id = p_plan

Line 3276: msc_plan_organizations mpo,

3272: msc_supplies ms,
3273: msc_items mi,
3274: msc_items mi2,
3275: msc_gantt_query mgq,
3276: msc_plan_organizations mpo,
3277: msc_plans mp
3278: where mgq.query_id = p_query_id
3279: and mgq.row_flag = SYS_YES
3280: and ( ( p_batched_res_act = RES_REQ_ROW_TYPE )

Line 3473: msc_plan_organizations mpo,

3469: to_char(sum(mrr.capacity_consumed_ratio))) bar_text
3470: from msc_resource_requirements mrr,
3471: msc_supplies ms,
3472: msc_gantt_query mgq,
3473: msc_plan_organizations mpo,
3474: msc_department_resources mdr,
3475: msc_plans mp
3476: where mgq.query_id = p_query_id
3477: and mgq.row_flag = SYS_YES