APPS.PO_APPROVED_SUPPLIER_LIST_SV dependencies on PO_ASL_STATUSES

Line 252: -- Get the default status from po_asl_statuses. If no default status has

248: END;
249: /* GA FPI End */
250:
251: -- check to see if default asl status is available
252: -- Get the default status from po_asl_statuses. If no default status has
253: -- been selected, insert error message and terminate transaction.
254: BEGIN
255: --
256: SELECT status_id

Line 258: FROM po_asl_statuses

254: BEGIN
255: --
256: SELECT status_id
257: INTO x_asl_status_id
258: FROM po_asl_statuses
259: WHERE asl_default_flag = 'Y';
260: --
261: EXCEPTION
262: WHEN NO_DATA_FOUND THEN