APPS.QLTCONTB dependencies on QA_CHART_CONSTANTS

Line 178: FROM QA_CHART_CONSTANTS

174: range_average := range_sum / num_subgroups;
175:
176: -- compute the control limits
177: SELECT A2, D3, D4 INTO A2, D3, D4
178: FROM QA_CHART_CONSTANTS
179: WHERE SUBGROUP_SIZE = subgrp_size;
180:
181: UCL := round(grand_mean + (A2 * range_average), dec_prec);
182: LCL := round(grand_mean - (A2 * range_average), dec_prec);

Line 353: FROM QA_CHART_CONSTANTS

349: std_dev_average := std_dev_sum / num_subgroups;
350:
351: -- compute the control limits
352: SELECT A1, B3, B4 INTO A1, B3, B4
353: FROM QA_CHART_CONSTANTS
354: WHERE SUBGROUP_SIZE = subgrp_size;
355:
356: UCL := round(grand_mean + (A1 * std_dev_average), dec_prec);
357: LCL := round(grand_mean - (A1 * std_dev_average), dec_prec);

Line 573: FROM QA_CHART_CONSTANTS

569:
570: -- compute the control limits
571:
572: SELECT D3, D4, E2 INTO D3, D4, E2
573: FROM QA_CHART_CONSTANTS
574: WHERE SUBGROUP_SIZE = subgrp_size;
575:
576: UCL := round(grand_mean + (E2 * range_average), dec_prec);
577: LCL := round(grand_mean - (E2 * range_average), dec_prec);

Line 819: FROM QA_CHART_CONSTANTS

815:
816: -- compute the control limits
817:
818: SELECT A2, D3, D4 INTO A2, D3, D4
819: FROM QA_CHART_CONSTANTS
820: WHERE SUBGROUP_SIZE = subgrp_size;
821:
822: UCL := round(grand_mean + (A2 * range_average), dec_prec);
823: LCL := round(grand_mean - (A2 * range_average), dec_prec);