APPS.QA_SAMPLING_PKG dependencies on QA_SAMPLING_CUSTOM_RULES

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

1112:
1113: END; --end procedure
1114:
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

Line 1148: from QA_SAMPLING_CUSTOM_RULES qscr

1144:
1145: cursor custom_sample_cur
1146: is
1147: select sample_size
1148: from QA_SAMPLING_CUSTOM_RULES qscr
1149: where qscr.sampling_plan_id = p_sampling_plan_id
1150: and p_lot_size between qscr.min_lot_size
1151: and nvl(qscr.max_lot_size,p_lot_size);
1152: --max lot size could be null. this is the reason for nvl