652: l_delivery_assignment_id NUMBER;
653: l_par_delivery_assignment_id NUMBER;
654: l_lpn_id NUMBER;
655:
656: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
657: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
658:
659: CURSOR lpn_cur(p_delivery_id NUMBER) IS
660: SELECT wdd.lpn_id, wdd.organization_id
653: l_par_delivery_assignment_id NUMBER;
654: l_lpn_id NUMBER;
655:
656: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
657: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
658:
659: CURSOR lpn_cur(p_delivery_id NUMBER) IS
660: SELECT wdd.lpn_id, wdd.organization_id
661: FROM (SELECT delivery_detail_id