APPS.QA_SKIPLOT_UTILITY dependencies on QA_SKIPLOT_PROCESS_PLAN_RULES

Line 12: from qa_skiplot_process_plan_rules

8: p_process_plan_id in number)return number is
9:
10: cursor fr (pp_id in number) is
11: select min(rule_seq)
12: from qa_skiplot_process_plan_rules
13: where process_plan_id = pp_id;
14:
15: first_rule number;
16:

Line 298: from qa_skiplot_process_plan_rules

294: p_freq_denom OUT NOCOPY NUMBER) IS
295:
296: cursor rule (x_pp_id number, x_rule_seq number) is
297: select frequency_num, frequency_denom
298: from qa_skiplot_process_plan_rules
299: where process_plan_id = x_pp_id and
300: rule_seq = x_rule_seq;
301:
302: BEGIN

Line 397: qa_skiplot_process_plan_rules qsppr,

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
401: qspp.process_plan_id = :2 and

Line 724: from qa_skiplot_process_plan_rules

720: next_rule number;
721:
722: cursor rule (pp_id in number, current_rule in number)is
723: select min(rule_seq)
724: from qa_skiplot_process_plan_rules
725: where process_plan_id = pp_id and
726: rule_seq > current_rule;
727:
728: BEGIN