APPS.WIP_OPERATIONS_UTILITIES dependencies on WIP_SUB_OPERATION_RESOURCES
Line 412: FROM WIP_SUB_OPERATION_RESOURCES WSOR
408:
409: BEGIN
410: SELECT nvl(max(resource_seq_num), 10)
411: INTO l_wsor_max_res_seq_num 412: FROM WIP_SUB_OPERATION_RESOURCES WSOR 413: WHERE wip_entity_id = x_wip_entity_id
414: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num;
415: EXCEPTION
416: WHEN no_data_found THEN
Line 420: INSERT INTO WIP_SUB_OPERATION_RESOURCES
416: WHEN no_data_found THEN
417: null;
418: END;
419: 420: INSERT INTO WIP_SUB_OPERATION_RESOURCES 421: (wip_entity_id,
422: operation_seq_num,
423: resource_seq_num,
424: organization_id,