APPS.QA_SKIPLOT_UTILITY dependencies on QA_SKIPLOT_ASSOCIATION

Line 324: from qa_skiplot_association qsa,

320:
321: if p_txn = RCV then
322: open pp for
323: 'select qspp.process_plan_id
324: from qa_skiplot_association qsa,
325: qa_skiplot_process_plans qspp
326: where qsa.criteria_id = :1 and
327: qsa.process_id = :2 and
328: qsa.process_id = qspp.process_id and

Line 394: from qa_skiplot_association qsa,

390: qsps.rule_start_lot_id,
391: qsps.rule_start_date,
392: qsps.last_receipt_lot_id,
393: qsps.last_receipt_date
394: from qa_skiplot_association qsa,
395: qa_skiplot_processes qsp,
396: qa_skiplot_process_plans qspp,
397: qa_skiplot_process_plan_rules qsppr,
398: qa_skiplot_plan_states qsps

Line 570: from qa_skiplot_association qsa,

566: p_criteria_id IN NUMBER) IS
567:
568: cursor plan_states (x_cid number) is
569: select qspp.process_plan_id
570: from qa_skiplot_association qsa,
571: qa_skiplot_process_plans qspp
572: where qsa.criteria_id = x_cid and
573: qsa.process_id = qspp.process_id;
574:

Line 623: qa_skiplot_association qsa

619: cursor plan_states (x_pid number) is
620: select qspp.process_plan_id,
621: qsa.criteria_id
622: from qa_skiplot_process_plans qspp,
623: qa_skiplot_association qsa
624: where qspp.process_id = x_pid and
625: qspp.process_id = qsa.process_id;
626:
627: BEGIN

Line 818: update qa_skiplot_association

814: -- jezheng
815: -- Wed Mar 17 15:41:02 PST 2004
816: --
817: --if p_txn = RCV then
818: update qa_skiplot_association
819: set insp_stage = p_stage
820: where criteria_id = p_criteria_id and
821: process_id = p_process_id;
822: --end if;