APPS.QA_SAMPLING_PKG dependencies on QA_SAMPLING_STD_RULES

Line 1119: --and AQL and checks the QA_SAMPLING_STD_RULES table and return the std.

1115: --
1116: --This checks the QA_SAMPLING_CUSTOM_RULES table based on sampling plan id
1117: --and lot size and return the custom sample size if found. Otherwise, it
1118: --checks QA_SAMPLING_PLANS table and gets the standard code, c number
1119: --and AQL and checks the QA_SAMPLING_STD_RULES table and return the std.
1120: --sample size
1121: --Note: Some alterations to the table columns were being made
1122: --Please refer to detail design for more information
1123: --

Line 1160: from qa_sampling_std_rules qssr

1156: x_table_seq in number,
1157: x_lot_code in varchar2)
1158: is
1159: select sample_size, c_number, rejection_number
1160: from qa_sampling_std_rules qssr
1161: where qssr.sampling_std_code = x_std_code
1162: and qssr.aql = x_aql
1163: and qssr.table_seq = x_table_seq
1164: and qssr.lot_size_code = x_lot_code;