APPS.WIP_OP_RESOURCES_UTILITIES dependencies on WIP_SUB_OPERATION_RESOURCES

Line 20: FROM WIP_SUB_OPERATION_RESOURCES

16: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num
17: AND RESOURCE_SEQ_NUM = X_Resource_Seq_Num;
18: cursor sub_discrete_check is
19: SELECT count(*)
20: FROM WIP_SUB_OPERATION_RESOURCES
21: WHERE ORGANIZATION_ID = X_Organization_Id
22: AND WIP_ENTITY_ID = X_Wip_Entity_Id
23: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num
24: AND RESOURCE_SEQ_NUM = X_Resource_Seq_Num;

Line 290: delete from wip_sub_operation_resources wsor

286: x_return_status out nocopy varchar2) is
287: begin
288: x_return_status := fnd_api.g_ret_sts_success;
289:
290: delete from wip_sub_operation_resources wsor
291: where wip_entity_id = p_wip_entity_id
292: and nvl(repetitive_schedule_id, -1) = nvl(p_schedule_id, -1)
293: and not exists (select 1
294: from wip_operation_resources wor

Line 333: from wip_sub_operation_resources

329: schedule_seq_num,
330: substitute_group_num,
331: scheduled_flag,
332: null parent_resource_seq /* added for bug 4747951 */
333: from wip_sub_operation_resources
334: where wip_entity_id = p_wip_entity_id
335: and nvl(repetitive_schedule_id,-1) = nvl(p_schedule_id,-1)
336: and operation_seq_num = p_op_seq_num
337: )