APPS.BOM_RESOURCE_SHIFTS_PKG dependencies on BOM_RESOURCE_CHANGES
Line 12: (select 1 from bom_resource_changes
8: Dummy NUMBER;
9: BEGIN
10: message_name := 'BOM_CANNOT_DELETE_SHIFT';
11: select 1 into dummy from dual where not exists 12: (select 1 from bom_resource_changes 13: where department_id = X_Department_Id
14: and resource_id = X_Resource_Id
15: and shift_num = X_Shift_Num);
16: