DBA Data[Home] [Help]

APPS.WPS_CAPACITY_CHANGES_PKG dependencies on BOM_DEPARTMENT_RESOURCES

Line 95: FROM BOM_DEPARTMENT_RESOURCES

91:
92: --Get the schedule to instance flag for the department resource
93: SELECT SCHEDULE_TO_INSTANCE
94: INTO l_sch_instance
95: FROM BOM_DEPARTMENT_RESOURCES
96: WHERE DEPARTMENT_ID = l_department_id AND
97: RESOURCE_ID = l_resource_id;
98:
99: --Schedule_to_instance: 1 means resource is scheduled to instance

Line 571: FROM BOM_DEPARTMENT_RESOURCES

567: l_action_type := 2;
568: end if;
569:
570: SELECT CAPACITY_UNITS INTO l_max_units
571: FROM BOM_DEPARTMENT_RESOURCES
572: WHERE RESOURCE_ID = l_resource_id and
573: DEPARTMENT_ID = l_department_id;
574:
575: SELECT COUNT(*) INTO l_record_count