APPS.QA_SAMPLING_PKG dependencies on QA_SAMPLING_CUSTOM_RULES

Line 1177: --This checks the QA_SAMPLING_CUSTOM_RULES table based on sampling plan id

1173:
1174: END; --end procedure
1175:
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

Line 1209: from QA_SAMPLING_CUSTOM_RULES qscr

1205:
1206: cursor custom_sample_cur
1207: is
1208: select sample_size
1209: from QA_SAMPLING_CUSTOM_RULES qscr
1210: where qscr.sampling_plan_id = p_sampling_plan_id
1211: and p_lot_size between qscr.min_lot_size
1212: and nvl(qscr.max_lot_size,p_lot_size);
1213: --max lot size could be null. this is the reason for nvl