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