APPS.MSC_GET_BIS_VALUES dependencies on MSC_BIS_RES_SUMMARY

Line 416: FROM msc_bis_res_summary

412: v_exist boolean;
413:
414: CURSOR RES_ORG_CUR IS
415: SELECT sum(nvl(overutilization_cost,0))
416: FROM msc_bis_res_summary
417: WHERE plan_id = p_plan_id
418: AND nvl(period_type,0) = 0
419: AND organization_id = p_organization_id;
420:

Line 423: FROM msc_bis_res_summary

419: AND organization_id = p_organization_id;
420:
421: CURSOR RES_CUR IS
422: SELECT sum(nvl(overutilization_cost,0))
423: FROM msc_bis_res_summary
424: WHERE plan_id = p_plan_id
425: AND nvl(period_type,0) = 0;
426:
427:

Line 579: FROM msc_bis_res_summary

575: v_exist boolean;
576:
577: CURSOR RES_ORG_DATE_CUR IS
578: SELECT sum(nvl(overutilization_cost,0))
579: FROM msc_bis_res_summary
580: WHERE plan_id = p_plan_id
581: AND organization_id = p_organization_id
582: AND nvl(period_type,0) = 0
583: AND resource_date between l_start_date and l_end_Date;

Line 587: FROM msc_bis_res_summary

583: AND resource_date between l_start_date and l_end_Date;
584:
585: CURSOR RES_DATE_CUR IS
586: SELECT sum(nvl(overutilization_cost,0))
587: FROM msc_bis_res_summary
588: WHERE plan_id = p_plan_id
589: AND nvl(period_type,0) = 0
590: AND resource_date between l_start_date and l_end_Date;
591:

Line 1223: ' FROM msc_bis_res_summary res ' ||

1219: end if;
1220: if p_dept_class is null and
1221: p_res_group is null then
1222: sql_statement := sql_statement ||
1223: ' FROM msc_bis_res_summary res ' ||
1224: ' WHERE res.plan_id = :1 AND nvl(res.period_type,0) = 0 ';
1225: else
1226: sql_statement := sql_statement ||
1227: ' FROM msc_department_resources mdr, '||

Line 1228: ' msc_bis_res_summary res ' ||

1224: ' WHERE res.plan_id = :1 AND nvl(res.period_type,0) = 0 ';
1225: else
1226: sql_statement := sql_statement ||
1227: ' FROM msc_department_resources mdr, '||
1228: ' msc_bis_res_summary res ' ||
1229: ' WHERE res.plan_id = :1 AND nvl(res.period_type,0) = 0 ' ||
1230: ' AND mdr.department_id = res.department_id ' ||
1231: ' AND mdr.resource_id = res.resource_id ' ||
1232: ' AND mdr.plan_id = res.plan_id ' ||

Line 1430: ' FROM msc_bis_res_summary res ' ||

1426: end if;
1427: if p_dept_class is null and
1428: p_res_group is null then
1429: sql_statement := sql_statement ||
1430: ' FROM msc_bis_res_summary res ' ||
1431: ' WHERE res.plan_id = :1 AND nvl(res.period_type,0) = 0 '||
1432: ' AND res.resource_date '||
1433: ' between :8 and :9 ';
1434: else

Line 1437: ' msc_bis_res_summary res ' ||

1433: ' between :8 and :9 ';
1434: else
1435: sql_statement := sql_statement ||
1436: ' FROM msc_department_resources mdr, '||
1437: ' msc_bis_res_summary res ' ||
1438: ' WHERE res.plan_id = :1 AND nvl(res.period_type,0) = 0 ' ||
1439: ' AND res.resource_date '||
1440: ' between :8 and :9 ' ||
1441: ' AND mdr.department_id = res.department_id ' ||

Line 3166: msc_bis_res_summary res

3162: avg(nvl(res.utilization,0)),
3163: count(nvl(res.utilization,0)),
3164: sum(nvl(res.utilization,0))
3165: from msc_department_resources mdr,
3166: msc_bis_res_summary res
3167: where mdr.department_id = res.department_id
3168: AND mdr.resource_id = res.resource_id
3169: AND mdr.plan_id = res.plan_id
3170: AND mdr.sr_instance_id = res.sr_instance_id