[Home] [Help]
217:
218: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
219: into lv_yield
220: from msc_process_effectivity mpe,
221: msc_routings mr,
222: msc_resource_requirements mrr
223: where mpe.sr_instance_id = inst_id
224: and mpe.plan_id = pln_id
225: and mpe.process_sequence_id = process_seq_id
276:
277: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
278: into lv_yield_dis
279: from msc_process_effectivity mpe,
280: msc_routings mr,
281: msc_resource_requirements mrr
282: where mpe.sr_instance_id = inst_id
283: and mpe.plan_id = pln_id
284: and mpe.process_sequence_id = process_seq_id
338:
339: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
340: into lv_yield_dis
341: from msc_process_effectivity mpe,
342: msc_routings mr,
343: msc_resource_requirements mrr
344: where mpe.sr_instance_id = inst_id
345: and mpe.plan_id = pln_id
346: and mpe.process_sequence_id = process_seq_id