APPS.PO_APPROVED_SUPPLIER_LIST_SV dependencies on PO_ASL_STATUSES

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

259: END;
260: /* GA FPI End */
261:
262: -- check to see if default asl status is available
263: -- Get the default status from po_asl_statuses. If no default status has
264: -- been selected, insert error message and terminate transaction.
265: BEGIN
266: --
267: SELECT status_id

Line 269: FROM po_asl_statuses

265: BEGIN
266: --
267: SELECT status_id
268: INTO x_asl_status_id
269: FROM po_asl_statuses
270: WHERE asl_default_flag = 'Y';
271: --
272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN