APPS.QA_SKIPLOT_EVAL_ENGINE dependencies on QA_SKIPLOT_PROCESS_PLANS

Line 211: -- plan ids from qa_skiplot_process_plans table.

207: -- from qa_skiplot_association table. Put lot size and
208: -- effective date as restriction, we will get only one
209: -- process_id if any.
210: -- With this process_id, we can get multiple collection
211: -- plan ids from qa_skiplot_process_plans table.
212: -- jezheng
213: -- Tue Oct 30 17:47:20 PST 2001
214: --
215: cursor the_process (x_c_id number, x_lotsize number) is

Line 228: from qa_skiplot_process_plans qspp

224: nvl(qsa.lotsize_to, x_lotsize);
225:
226: cursor avail_plans (x_process_id number) is
227: select qspp.plan_id
228: from qa_skiplot_process_plans qspp
229: where qspp.process_id = x_process_id;
230:
231: BEGIN
232: /* p_lot_qty is in transaction_uom. so it is converted to primary_uom*/

Line 317: FROM qa_skiplot_process_plans qspp,

313:
314: -- Bug 3959767 fetches qualification rounds
315: CURSOR qualification_rounds(x_process_id NUMBER) IS
316: SELECT qsppr.rounds
317: FROM qa_skiplot_process_plans qspp,
318: qa_skiplot_process_plan_rules qsppr
319: WHERE qspp.process_id = x_process_id
320: AND qspp.process_plan_id = qsppr.process_plan_id
321: AND qsppr.rule_seq=0;

Line 351: FROM qa_skiplot_process_plans qspp, qa_skiplot_association qsa

347: -- bhsankar Wed Aug 22 01:16:48 PDT 2007
348: --
349: CURSOR plan_det (x_pid NUMBER, x_crit_id NUMBER) IS
350: SELECT qspp.process_plan_id
351: FROM qa_skiplot_process_plans qspp, qa_skiplot_association qsa
352: WHERE qspp.process_id = qsa.process_id AND
353: qsa.criteria_id = x_crit_id AND
354: qspp.process_id = x_pid;
355: