234: l_progress := '000';
235:
236: select status_id
237: into x_status_id
238: from po_asl_statuses
239: where status = x_status;
240:
241: if NVL(x_global_asl_update,'N') = 'N' then
242: l_progress := '010';
429: x_default_status,
430: x_default_business_code,
431: x_default_business,
432: x_po_item_master_org_id
433: FROM po_asl_statuses past,
434: po_lookup_codes plc,
435: financials_system_parameters fsp
436: WHERE past.asl_default_flag = 'Y'
437: AND plc.lookup_type = 'ASL_VENDOR_BUSINESS_TYPE'