APPS.GMO_VBATCH_PVT dependencies on GMO_INSTR_INSTANCE_B

Line 924: 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;

920:
921: 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;
922: cursor get_min_material_for_step is select min(material_detail_id) from gme_batch_step_items where batchstep_id = l_batchstep_id;
923:
924: 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;
925:
926: cursor get_task is select task_name from gmo_instr_task_defn_b where task_id = l_task_id;
927:
928: BEGIN

Line 1087: update gmo_instr_instance_b set task_attribute_id = l_task_attribute_id_inst

1083: end if;
1084:
1085: if (l_task_attribute is not null) then
1086: if (l_task_attribute_id_inst is not null) then
1087: update gmo_instr_instance_b set task_attribute_id = l_task_attribute_id_inst
1088: where instruction_set_id = P_INSTRUCTION_SET_ID
1089: and instruction_id = l_instruction_id;
1090: elsif (l_min_assoc = 'N') then
1091: j := j + 1;