APPS.PO_ASL_API_PUB dependencies on PO_ASL_STATUSES

Line 1396: FROM po_asl_statuses pas

1392:
1393: UPDATE po_approved_supplier_list_gt past
1394: SET past.asl_status_id =
1395: (SELECT pas.status_id
1396: FROM po_asl_statuses pas
1397: WHERE past.asl_status_dsp = pas.status
1398: AND ROWNUM < 2)
1399: WHERE past.asl_status_dsp IS NOT NULL;
1400: l_progress := 30;

Line 1455: po_asl_statuses past,

1451: SET asl1.manufacturer_asl_id =
1452: (SELECT pasl.asl_id
1453: FROM po_approved_supplier_list pasl,
1454: mtl_manufacturers mm,
1455: po_asl_statuses past,
1456: po_asl_status_rules psr
1457: WHERE pasl.manufacturer_id = mm.manufacturer_id
1458: AND pasl.asl_status_id = past.status_id
1459: AND psr.status_id = past.status_id