APPS.QA_SKIPLOT_EVAL_ENGINE dependencies on QA_SKIPLOT_PROCESS_PLANS

Line 265: -- plan ids from qa_skiplot_process_plans table.

261: -- from qa_skiplot_association table. Put lot size and
262: -- effective date as restriction, we will get only one
263: -- process_id if any.
264: -- With this process_id, we can get multiple collection
265: -- plan ids from qa_skiplot_process_plans table.
266: -- jezheng
267: -- Tue Oct 30 17:47:20 PST 2001
268: --
269: cursor the_process (x_c_id number, x_lotsize number) is

Line 282: from qa_skiplot_process_plans qspp

278: nvl(qsa.lotsize_to, x_lotsize);
279:
280: cursor avail_plans (x_process_id number) is
281: select qspp.plan_id
282: from qa_skiplot_process_plans qspp
283: where qspp.process_id = x_process_id;
284:
285: BEGIN
286: /* p_lot_qty is in transaction_uom. so it is converted to primary_uom*/

Line 371: FROM qa_skiplot_process_plans qspp,

367:
368: -- Bug 3959767 fetches qualification rounds
369: CURSOR qualification_rounds(x_process_id NUMBER) IS
370: SELECT qsppr.rounds
371: FROM qa_skiplot_process_plans qspp,
372: qa_skiplot_process_plan_rules qsppr
373: WHERE qspp.process_id = x_process_id
374: AND qspp.process_plan_id = qsppr.process_plan_id
375: AND qsppr.rule_seq=0;

Line 405: FROM qa_skiplot_process_plans qspp, qa_skiplot_association qsa

401: -- bhsankar Wed Aug 22 01:16:48 PDT 2007
402: --
403: CURSOR plan_det (x_pid NUMBER, x_crit_id NUMBER) IS
404: SELECT qspp.process_plan_id
405: FROM qa_skiplot_process_plans qspp, qa_skiplot_association qsa
406: WHERE qspp.process_id = qsa.process_id AND
407: qsa.criteria_id = x_crit_id AND
408: qspp.process_id = x_pid;
409: