APPS.MSC_UPDATE_RESOURCE dependencies on MSC_DEPARTMENT_RESOURCES

Line 1297: FROM msc_department_resources res

1293:
1294: CURSOR net_resource IS
1295: SELECT res.department_id, res.resource_id,
1296: res.organization_id, res.sr_instance_id
1297: FROM msc_department_resources res
1298: WHERE plan_id = v_plan_id;
1299:
1300: TYPE resource_table IS RECORD
1301: ( dept_id NUMBER,

Line 1375: ' from msc_department_resources where NVL(department_class,''@@@'') '||

1371: ' and department_id in (' || p_dept_list || ')';
1372: ELSIF p_dept_class_list IS NOT NULL THEN
1373: where_statement := where_statement ||
1374: ' and department_id in (select distinct department_id ' ||
1375: ' from msc_department_resources where NVL(department_class,''@@@'') '||
1376: ' in (' || p_dept_class_list || ') and plan_id = '
1377: ||to_char(v_plan_id)||
1378: ' and (sr_instance_id, organization_id) in ('||p_org_instance_list ||'))';
1379: ELSIF p_res_group_list IS NOT NULL THEN

Line 1382: ' department_id, resource_id from msc_department_resources where ' ||

1378: ' and (sr_instance_id, organization_id) in ('||p_org_instance_list ||'))';
1379: ELSIF p_res_group_list IS NOT NULL THEN
1380: where_statement := where_statement ||
1381: ' and (department_id, resource_id) in (select '||
1382: ' department_id, resource_id from msc_department_resources where ' ||
1383: ' NVL(resource_group_name,''@@@'') in ('
1384: || p_res_group_list || ') and '||
1385: ' plan_id = '||to_char(v_plan_id)||
1386: ' and (sr_instance_id, organization_id) in ('||

Line 1489: from msc_department_resources

1485:
1486: v_agg_resource number;
1487: CURSOR agg_resource IS
1488: SELECT aggregate_resource_flag
1489: from msc_department_resources
1490: where plan_id = v_plan_id
1491: and sr_instance_id = p_instance_id
1492: and organization_id = p_org_id
1493: AND department_id = p_dept_id