DBA Data[Home] [Help]

APPS.PO_ASL_SV dependencies on PO_ASL_STATUSES

Line 238: from po_asl_statuses

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';

Line 437: FROM po_asl_statuses past,

433: x_default_status,
434: x_default_business_code,
435: x_default_business
436: --x_po_item_master_org_id
437: FROM po_asl_statuses past,
438: po_lookup_codes plc
439: --financials_system_parameters fsp
440: WHERE past.asl_default_flag = 'Y'
441: AND plc.lookup_type = 'ASL_VENDOR_BUSINESS_TYPE'