APPS.GMO_VBATCH_PVT dependencies on GMO_INSTR_INSTANCE_B

Line 969: cursor get_instr_details is select instr_number, instruction_id, task_id, task_attribute_id from gmo_instr_instance_b where instruction_set_id = P_INSTRUCTION_SET_ID;

965:
966: cursor get_material is select material_detail_id from gme_material_details where formulaline_id = l_formula_line_id and batch_id = l_batch_id;
967: cursor get_min_material_for_step is select min(material_detail_id) from gme_batch_step_items where batchstep_id = l_batchstep_id;
968:
969: cursor get_instr_details is select instr_number, instruction_id, task_id, task_attribute_id from gmo_instr_instance_b where instruction_set_id = P_INSTRUCTION_SET_ID;
970:
971: cursor get_task is select task_name from gmo_instr_task_defn_b where task_id = l_task_id;
972:
973: BEGIN

Line 1132: update gmo_instr_instance_b set task_attribute_id = l_task_attribute_id_inst

1128: end if;
1129:
1130: if (l_task_attribute is not null) then
1131: if (l_task_attribute_id_inst is not null) then
1132: update gmo_instr_instance_b set task_attribute_id = l_task_attribute_id_inst
1133: where instruction_set_id = P_INSTRUCTION_SET_ID
1134: and instruction_id = l_instruction_id;
1135: elsif (l_min_assoc = 'N') then
1136: j := j + 1;