147: FORMULA_NO,
148: FORMULA_VERS
149: INTO FLD1,FLD2
150: FROM
151: FM_FORM_EFF EFF,
152: FM_FORM_MST MST
153: WHERE EFF.FMEFF_ID = FRM_ID
154: AND EFF.FORMULA_ID = MST.FORMULA_ID;
155: FORMULA_NOCP := FLD1;
160: ROUTING_NO,
161: ROUTING_VERS
162: INTO FLD3,FLD4
163: FROM
164: FM_FORM_EFF EFF,
165: FM_ROUT_HDR HDR
166: WHERE EFF.FMEFF_ID = FRM_ID
167: AND EFF.ROUTING_ID = HDR.ROUTING_ID;
168: ROUTING_NOCP := FLD3;
188: FORMULA_NO,
189: FORMULA_VERS
190: INTO FLD1,FLD2
191: FROM
192: FM_FORM_EFF EFF,
193: FM_FORM_MST MST
194: WHERE EFF.FMEFF_ID = FRM_ID_DTL
195: AND EFF.FORMULA_ID = MST.FORMULA_ID;
196: FORMULA_NO1CP := FLD1;
201: ROUTING_NO,
202: ROUTING_VERS
203: INTO FLD3,FLD4
204: FROM
205: FM_FORM_EFF EFF,
206: FM_ROUT_HDR HDR
207: WHERE EFF.FMEFF_ID = FRM_ID_DTL
208: AND EFF.ROUTING_ID = HDR.ROUTING_ID;
209: ROUTING_NO1CP := FLD3;