APPS.QA_SAMPLING_PKG dependencies on QA_SAMPLING_STD_RULES

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

1176: --
1177: --This checks the QA_SAMPLING_CUSTOM_RULES table based on sampling plan id
1178: --and lot size and return the custom sample size if found. Otherwise, it
1179: --checks QA_SAMPLING_PLANS table and gets the standard code, c number
1180: --and AQL and checks the QA_SAMPLING_STD_RULES table and return the std.
1181: --sample size
1182: --Note: Some alterations to the table columns were being made
1183: --Please refer to detail design for more information
1184: --

Line 1221: from qa_sampling_std_rules qssr

1217: x_table_seq in number,
1218: x_lot_code in varchar2)
1219: is
1220: select sample_size, c_number, rejection_number
1221: from qa_sampling_std_rules qssr
1222: where qssr.sampling_std_code = x_std_code
1223: and qssr.aql = x_aql
1224: and qssr.table_seq = x_table_seq
1225: and qssr.lot_size_code = x_lot_code;