APPS.MSC_PMF_PKG dependencies on MSC_EXCEPTION_THRESHOLD_VALUES

Line 102: from msc_exception_threshold_values

98: rec_found := true;
99:
100: select value
101: into l_thresh_value
102: from msc_exception_threshold_values
103: where exception_type = p_exception_type
104: and company_id = p_company_id
105: and company_site_id = p_company_site_id
106: and inventory_item_id = p_inventory_item_id

Line 128: from msc_exception_threshold_values

124: rec_found := true;
125:
126: select value
127: into l_thresh_value
128: from msc_exception_threshold_values
129: where exception_type = p_exception_type
130: and company_id = p_company_id
131: and company_site_id = p_company_site_id
132: and inventory_item_id = p_inventory_item_id

Line 166: from msc_exception_threshold_values

162: rec_found := true;
163:
164: select value
165: into l_thresh_value
166: from msc_exception_threshold_values
167: where exception_type = p_exception_type
168: and company_id = p_company_id
169: and company_site_id = p_company_site_id
170: and inventory_item_id = p_inventory_item_id

Line 190: from msc_exception_threshold_values

186: rec_found := true;
187:
188: select value
189: into l_thresh_value
190: from msc_exception_threshold_values
191: where exception_type = p_exception_type
192: and company_id = p_company_id
193: and company_site_id = p_company_site_id
194: and inventory_item_id = p_inventory_item_id

Line 227: from msc_exception_threshold_values

223: rec_found := true;
224:
225: select value
226: into l_thresh_value
227: from msc_exception_threshold_values
228: where exception_type = p_exception_type
229: and company_id = p_company_id
230: and inventory_item_id = p_inventory_item_id
231: and supplier_id = p_supplier_id;

Line 249: from msc_exception_threshold_values

245: rec_found := true;
246:
247: select value
248: into l_thresh_value
249: from msc_exception_threshold_values
250: where exception_type = p_exception_type
251: and company_id = p_company_id
252: and inventory_item_id = p_inventory_item_id
253: and customer_id = p_customer_id;

Line 284: from msc_exception_threshold_values

280: rec_found := true;
281:
282: select value
283: into l_thresh_value
284: from msc_exception_threshold_values
285: where exception_type = p_exception_type
286: and company_id = p_company_id
287: and supplier_id = p_supplier_id;
288:

Line 304: from msc_exception_threshold_values

300: rec_found := true;
301:
302: select value
303: into l_thresh_value
304: from msc_exception_threshold_values
305: where exception_type = p_exception_type
306: and company_id = p_company_id
307: and customer_id = p_customer_id;
308:

Line 336: from msc_exception_threshold_values

332: rec_found := true;
333:
334: select value
335: into l_thresh_value
336: from msc_exception_threshold_values
337: where exception_type = p_exception_type
338: and company_id = p_company_id
339: and company_site_id is NULL
340: and inventory_item_id is NULL