APPS.MSC_BI2EBS_PKG dependencies on MSC_DEPARTMENT_RESOURCES

Line 113: FROM MSC_DEPARTMENT_RESOURCES MDR, MFG_LOOKUPS ML1,MFG_LOOKUPS ML2

109: and plan_id = p_plan_id;
110:
111: cursor c_res_id (p_plan_id number, p_res_name varchar2) is
112: SELECT unique MDR.RESOURCE_ID
113: FROM MSC_DEPARTMENT_RESOURCES MDR, MFG_LOOKUPS ML1,MFG_LOOKUPS ML2
114: where MDR.RESOURCE_CODE = p_res_name
115: and mdr.plan_id =p_plan_id
116: and ML1.LOOKUP_CODE = nvl(MDR.BOTTLENECK_FLAG,2)
117: AND ML1.LOOKUP_TYPE = 'SYS_YES_NO'