APPS.QA_SKIPLOT_EVAL_ENGINE dependencies on QA_SKIPLOT_ASSOCIATION

Line 207: -- from qa_skiplot_association table. Put lot size and

203: primary_lot_qty NUMBER;
204:
205: --
206: -- given a criteria_id, we can get multiple process_ids
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.

Line 217: from qa_skiplot_association qsa

213: -- Tue Oct 30 17:47:20 PST 2001
214: --
215: cursor the_process (x_c_id number, x_lotsize number) is
216: select qsa.process_id
217: from qa_skiplot_association qsa
218: where qsa.criteria_id = x_c_id and
219: trunc(sysdate) between
220: nvl(trunc(qsa.effective_from), trunc(sysdate)) and
221: nvl(trunc(qsa.effective_to), trunc(sysdate)) and

Line 310: FROM qa_skiplot_association

306: -- SHKALYAN 01-May-2006
307:
308: CURSOR insp_stage(x_crit_id NUMBER, x_process_id NUMBER) IS
309: SELECT INSP_STAGE
310: FROM qa_skiplot_association
311: WHERE criteria_id = x_crit_id
312: AND process_id = x_process_id;
313:
314: -- Bug 3959767 fetches qualification rounds

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: