APPS.QA_SKIPLOT_UTILITY dependencies on QA_SKIPLOT_PROCESS_PLANS

Line 325: qa_skiplot_process_plans qspp

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
329: qspp.plan_id = :3'

Line 396: qa_skiplot_process_plans qspp,

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
399: where qsa.criteria_id = :1 and
400: qsp.process_id = qsa.process_id and

Line 429: from qa_skiplot_process_plans qspp

425: p_txn IN NUMBER) IS
426:
427: cursor p_plans (x_pid number) is
428: select qspp.process_plan_id
429: from qa_skiplot_process_plans qspp
430: where process_id = x_pid;
431:
432: BEGIN
433:

Line 571: qa_skiplot_process_plans qspp

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:
575: BEGIN

Line 622: from qa_skiplot_process_plans qspp,

618:
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:

Line 917: from qa_skiplot_processes qsp, qa_skiplot_process_plans qspp

913: p_process_desc out NOCOPY varchar2) is
914:
915: cursor process_info (x_ppid number) is
916: select qsp.process_id, qsp.process_code, qsp.description
917: from qa_skiplot_processes qsp, qa_skiplot_process_plans qspp
918: where qspp.process_plan_id = x_ppid and
919: qspp.process_id = qsp.process_id;
920:
921: begin

Line 1054: from qa_plans qp, qa_skiplot_process_plans qspp

1050: p_process_plan_id in number)return varchar2 is
1051:
1052: cursor coll_plan (x_process_plan_id number) is
1053: select qp.name
1054: from qa_plans qp, qa_skiplot_process_plans qspp
1055: where qspp.process_plan_id = x_process_plan_id and
1056: qspp.plan_id = qp.plan_id;
1057:
1058: x_coll_plan_name varchar2(30);

Line 1385: from qa_skiplot_process_plans

1381: p_process_plan_id IN NUMBER) RETURN NUMBER IS
1382:
1383: cursor pid (x_ppid number) is
1384: select process_id
1385: from qa_skiplot_process_plans
1386: where process_plan_id = x_ppid;
1387: proc_id number;
1388:
1389: BEGIN